I have a range of numbers ranging from 0 to 48 in rows.
48 being excellent and 0 being bad.
I want to reverse this:
0 to 48
1 to 47
2 to 46 etc
Anyone know how I would do this?
Thanks
Er, just take the current value away from 48?
I have a range of numbers ranging from 0 to 48 in rows.
48 being excellent and 0 being bad.
I want to reverse this:
0 to 48
1 to 47
2 to 46 etc
Anyone know how I would do this?
Thanks
Er, just take the current value away from 48?
Hmm yes that's one way of looking at it .Yeah thanks, i was just over thinking this lol.
=48-[corresponding cell]