Hi All,
Need help with a IF Statment - I have attached a example spreadsheet.
What I am trying to do:
- Col F: is deriving total mins using =(C2+D2)-(A2+B2) and using a custom format [m] to show me mins.
- Col H: is where I want to calculate my 4 HR SLA.
So to sum it up IF Col F is <= to 240 show me a 1. IF Col F is > then 240 then show me a 0.
However this is where I am having problems the formuale I am using for Col H: =IF(F2<=240,1,0) which is not derving the correct value of 1 or 0. Can someone please shed some light on this for me. I am still new to excel and have a hit roadblock. Your assistance will be grealty appreciated.
Regards,
Ravi
Bookmarks