=SUM Then insert word.

[iwgunter]

I need a, in my book, complex function:


Code:
--------------------
=SUM C2-B2
IF < 0 { } ELSE IF == 0 { 0 Days } ELSE IF == 1 { 1 Day } ELSE IF >= 2 { * Days }
--------------------


This is probably written all wrong, but I'm used to writing in PHP, not
Excel Functions.

Basically IF result is less than 0 leave cell empty, IF result is 1
enter "1 Day", IF result is greater or equal to 2 enter "[result]
Days".


Many Thanks
Ian Gunter

 

[Alex Delamain]

This should do it

=IF(C2-B2<=0,"",IF(C2-B2=1,"1 day",+C2-B2&" Days")

 

[Arvi Laanemets]

Hi

=IF(OR(C2="",B2="",C2-B2<0),"",(C2-B2) & " Day" & IF(C2-B2=1,"","s")))

 

[Guest]

Hi,
Try
=IF(C2-B2=0,"",IF(C2-B2=1,"1 DAY",IF(C2-B2>= 2, C2-B2 & " Days","N/A")))