I'm trying to make a cell do the following :
if cell H12 is above 5 show "above", if it is below -5 show "below", if it is between -5 and 5 (not including 5 or -5) show in line.
Can anyone tell me what I need to type in... I have tried all sorts !:confused:
Big thanks in advance