Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested Function | Excel Discussion (Misc queries) | |||
can you nested sum and round function within if function? | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Nested Function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |