# IF Statement to derive a TRUE or FALES formula

1. ## IF Statement to derive a TRUE or FALES formula

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  Register To Reply

2. ## Re: IF Statement to derive a TRUE or FALES formula

Try this....... ``Please Login or Register  to view this content.``  Register To Reply

3. ## Re: IF Statement to derive a TRUE or FALES formula

Try this:

=IF(F2<=0.166666667,1,0)

This uses the underlying value of a custom formatted cell showing 240 minutes.  Register To Reply

4. ## Re: IF Statement to derive a TRUE or FALES formula

Or

In H2 Cell

=(VALUE(TEXT(F2,"[m]"))<=240)*1

Drag it down...  Register To Reply

5. ## Re: IF Statement to derive a TRUE or FALES formula

Hi Guys,

Thanks for the assistance sktneer, AliGW and Sixthsense all three formula's suggested below works perfectly fine. Thanks again for you time and help greatly appreciated.

Regards,
Ravi  Register To Reply

6. ## Re: IF Statement to derive a TRUE or FALES formula

You're welcome.   Register To Reply

7. ## Re: IF Statement to derive a TRUE or FALES formula

Hi All,

Quick question - one variable i had forgotten if the Cell has no value how do I show if i.e Col F has no value meaning a blank cell then for Col H to show blank. Sorry I should have stated as well.  Register To Reply

8. ## Re: IF Statement to derive a TRUE or FALES formula

Like this...... ``Please Login or Register  to view this content.``  Register To Reply

9. ## Re: IF Statement to derive a TRUE or FALES formula

Thanks sktneer really appreciate your help. Regards, Ravu  Register To Reply