Hi there - I'm after some help. I'm want to build in a calculation that says ...
if B1 is between -15 (inclusive) or beyond (i.e. further off into the minus numbers), then show A1
if B1 is between -8 and -14 (both numbers inclusive), then show A2
if B1 is between -1 and -7 (both numbers inclusive), then show A3
if B1 is between 0 and 7 (both numbers inclusive), then show A4
if B1 is between 8 and 14 (both numbers inclusive), then show A5
if B1 is greater than or equal to 15, then show A6
How do I write that calculation? ENORMOUSLY appreciate - any advice.
Thanks
Gary
Bookmarks