Having Excel IF formulas print text And calc [Solved/Closed]

martinwuff - Mar 6, 2009 at 09:00 AM - Latest reply:  martinwuff
- Mar 6, 2009 at 12:21 PM

I am trying to get Excel IF formulas to print a text and calculation based on true/false. Such as, if I have some dates, and I dont need to send a notice to a deptartment if they still have 15 days to fix something, I say No Notice. But if they have less than 15 days, I want it to print "This department only has xx days remaining".

=IF([cell]>=15,"No Notice","This Department only has [15-[cell]] days left")

I can only seem to find how to print text OR a calculation, not both in the same. :(
I know I could add another column after with a blank or "days left to complete", but I wanted to know if I could do it all in one IF statement.

See more 

2 replies

Best answer
Thank you
=IF([cell]>=15,"No Notice",IF([cell]<15,"This department only has "&ROUNDUP([cell],0)&"days left",""))

Hope this helps.

Thank you, CIDA 16

Something to say? Add comment

CCM has helped 1700 users this month

Yes it did! THe format that I needed was basically "&([cell])&" is the & signs that I needed. Thanks so much!!