IF function using negative numbers an 3 options

[22222222]

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 !

Big thanks in advance

 

[Jonmo1]

Welcome to the board.

Try
=IF(H12<-5,"below",IF(H12>5,"above","in line"))

 

[22222222]

Thank you soooooooo much !!!
Id it possible to apply a colour to each e.g. in line is blue, below is red etc?
or would I have to use a conditional format to do this?

Huge thanks

 

[Jonmo1]

Glad to help, thanks for the feedback.

Yes, You need conditional formatting for that..

 

[Aladin Akyurek]

What if H12 = -5 or if H2 = 5?

 

[22222222]

Just having one small problem , it seems to be showing "in line" for everything
any help - greatly appreciated
thanks

 

[Jonmo1]

Just having one small problem , it seems to be showing "in line" for everything
any help - greatly appreciated
thanks

That would mean all your numbers are between (and including) -5 and 5

Are you sure your numbers are whole numbers and not decimals?
Are they perhaps 0.xx ?

 

[22222222]

They were % - I forgot to mention that !
I've put the % sign in and it works! - big thank you it will save me hours of work