View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PWK PWK is offline
external usenet poster
 
Posts: 27
Default Nested IF function

Hello All

=IF(ISBLANK(D2),"",TEXT(D2+3,"ddd"),IF(D2="Sun","M on",D2)))

I am using this function in a worksheet to insert day of week. When
the day "Sun" occurs I want "Mon" to show in the cell instead (I get a
too many argument error). I get very confused with nested functions.
Thanks for your help.