Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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

Report
-
 martinwuff -
Hello,

I am trying to get Excel IF formulas to print text and calculation based on true/false. Such as, if I have some dates, and I don't need to send a notice to a department 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.

Thanks!
System Configuration: Windows XP Internet Explorer 7.0
See more
Related:

1 reply

Answer 1 / 1

Hey, 

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


Hope this helps!
20
Thank you
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Report

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!