if statement with multiple trues but only one false

[lucinenecka]

Hello,

As it's Saturday and I'm working my brain decided against it.....

Could anyone help me to write if statement or any other formula: if cell C3 is less then 0 then "over due", if = 0 then "due" and if more then zero then "not due yet" otherwise preferably nothing, because that would mean that the cell is empty.

Thank you very much
Lucie

 

[njimack]

=IF(C3="","",IF(C3<0,"over due",IF(C3=0,"due","not due yet")))

 

[VoG]

Try

=IF(C3<0,"overdue",IF(C3=0,"due",""))

 

[teylyn]

Or

=IF(LEN(C3)>0,LOOKUP(C3,{-1000,0,1},{"over due [sic!]","due","not due yet"}),"")

 

[lucinenecka]

Thank you very much for your ever so quick reply. It works perfectly. I have two more questions, not sure if I can ask under this title, but will try anyway. I'm new to this forum.
1. The formulas in my spreadsheet suddenly won't work/update unless I press save button.
2. This worksheet is list of incoming post items being filled in by macro driven input form from same workbook. Can it be shared and used by multiple users at the same time or have I spent a lot of time by creating something of no value for our purposes.

 

[VoG]

For #1 check in Tools > Options > Calculation tab that calculation is set to Automatic.

Foe #2 I suggest that you start a new thread.

 

[lucinenecka]

Thank you!