# 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

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

Try this.......

``Please Login or Register  to view this content.``

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.

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

Or

In H2 Cell

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

Drag it down...

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

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

You're welcome.

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.

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

Like this......

``Please Login or Register  to view this content.``

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

Thanks sktneer really appreciate your help. Regards, Ravu

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1