Using IF and OR within formula

[DrillinHole]

Alright, the formula I currently have is this:
=IF(H31>0,"ABOVE: "&H31&"'")

What I need to know, is how to use the IF and/or OR function to represent the opposite. What I mean is, if H31 is >0, I want the cell to show ABOVE: 44' (or whatever the value of H31 is). If H31<0, I want the cell to show BELOW: 44' (or whatever the value of H31 is).

To take it a step further, in that same formula, if H31=0, I want the cell to show "A/B: ON LINE".

I've always thought I had a great understanding of Excel, but I can't seem to figure this one out.

Thanks for all your help!

[FDibbins]

Hi and welcome to the forum

Your IF() function is only partly complete, you left off the 3rd part...
=IF(this-is-true,do-this,-else-do-that) You left off the else-do-that part, and this is where you would put the extra part you want

=IF(H31>0,"ABOVE: "&H31&"'","BELOW: "&H31&"'")

[DrillinHole]

Ford,

Thanks buddy! That makes sense lol. Now that I have that resolved, is there a way to take the (-) out of the cell that contains the formluat? What I mean is, if H31 = -23, A15(where the formula is located) reflects "BELOW: -23'". I don't want the "-" to be in A15. I want it to reflect just "BELOW: 23'".

Thanks again Bud!

[FDibbins]

Maybe this...
=IF(H31>0,"ABOVE: "&H31&"'","BELOW: "&ABS(H31)&"'")

[DrillinHole]

Maybe this...
=IF(H31>0,"ABOVE: "&H31&"'","BELOW: "&ABS(H31)&"'")

Ford,

You are a life saver!!! That worked exactly the way I need it to! Now is there a way to add the second part within the same formula? Because with my sheet, if the value of H31 is "0", I need A15 to reflect "A/B: On Line".

I'm really sorry to ask so much, especially since I'm new and haven't gotten the chance to contribute to this awesome forum!