View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
nascarjc
 
Posts: n/a
Default 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