Search : in
By :

Having Excel IF formulas print text And calc

Last answer on Jun 15, 2009 9:05:56 pm BST martinwuff, on Mar 6, 2009 2:00:31 pm GMT 
 Report this message to moderators

Hello,

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.

Thanks!

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « Having Excel IF formulas print text And calc » in :
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
How to freeze a row in an excel sheet ShowHow to freeze a row in an excel sheet To freeze a line in an excel sheet, for example line 1: Select line 2. Go to menu Window and select Freeze panes.
Printing Basics ShowPrinting Basics The method Resolution Saving your work Conclusion Whwn you make a print preview on your PC, all seems to be Ok, but that's only what is displayed on your screen , in reality its a totally different matter. Ther ...
Quoted-printable encoding ShowQuoted-printable encoding Quoted-printable encoding (somtimes QP) involves using US-ASCII 7-bits encoding (non-accented letters) to encode a text that requires an alphabet of 8-bit characters (accented letters), such as ISO-Latin-1, which is used...
Ask your question Reply

1

CIDA, on Mar 6, 2009 4:46:08 pm GMT
  • +3

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

Hope this helps.

   
Reply to CIDA

2

 martinwuff, on Mar 6, 2009 5:21:35 pm GMT

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

   
Reply to martinwuff
Ask your question Reply
They need your help