| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help to understand "IF" code
Hello all, This is the first time in here. I have a question about a line of code which has today() and weekday() in it. Can someone explain this for me so that I may understand it better? The person who did it can't explain it so hopefully you can. Thanks in advance. =IF(E8="HO","HO",IF(E5=12,"X",IF((TODAY()+1)E6,IF ((WEEKDAY(E6,2)5),"",IF(E8="OT","OT",IF(E9="FH",8 ,IF(E5=11,8,9)))),""))) JC -- nascarjc ------------------------------------------------------------------------ nascarjc's Profile: http://www.excelforum.com/member.php...o&userid=31002 View this thread: http://www.excelforum.com/showthread...hreadid=506697 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change case...help please | Excel Worksheet Functions | |||
| Macro for changing text to Proper Case | Excel Worksheet Functions | |||
| Using other workbooks.. | Excel Worksheet Functions | |||
| Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
| Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Threaded Mode
