View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default Entering IF formula

=if(a1="","",a1+180)

--
Regards,
Fred


"PamiS" wrote in message
...
I am very new to Excel and need to enter a formula for work asap.

What is the formula to enter: if cell A1 is blank then enter blank and if
not enter the date in A1 plus 180 days?

Help!