=if(c3>0,"over","")

[PacificQuest]

Afternoon,

I'm using the above formula to show "OVER" if a value is greater than zero, however I'd also like it to show "UNDER" if the value is less than zero.

Is it as simple as the =IF(OR command?

Thanks in advance,
PQ

 

[barry houdini]

You can use this formula

=IF(C3>0,"Over",IF(C3<0,"Under",""))

 

[VoG]

Try

=IF(C3>0,"Over",IF(C3<0,"Under",""))

 

[Smitty]

Welcome to the Board!

How's this:

=IF(C3>0,"Over",IF(C3<0,"Under",""))

What if it's equal to 0?

HTH,

 

[PacificQuest]

Many thanks for your speedy responses, that's exactly what I needed.

NB: If the value equals 0 then the cell just needs to stay blank ...

Thank again,
PQ