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.
System Configuration: Windows XP Internet Explorer 7.0