# IF formula help

1. ## IF formula help

Ok I have an if formula in my spread sheet currently that figures run hours. if the actual run hours are less than .2 it enters .2, if they are greater they enter the actual time. Is there a way that I can adjust the formula so if run hours equals 0 it will enter 0 and the above can stay the same. Here is a copy of the current formula:

=IF(D6/(\$B\$11*60)>=0.2,D6/(\$B\$11*60),0.2)

If it can't be done any suggestions on how to get it accomplished? Thanks in advance.  Register To Reply

2. ## Re: IF formula help

You can add another IF around the current one...

=IF(D6/(\$B\$11*60)=0,0,IF(D6/(\$B\$11*60)>=0.2,D6/(\$B\$11*60),0.2))  Register To Reply

3. ## Re: IF formula help

thanks worked like a charm.  Register To Reply

4. ## Re: IF formula help

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save  Register To Reply

5. ## Re: IF formula help

Or try this:

=IF(D6>0;MAX(D6/(\$B\$11*60);0,2);0)

(replace ; with , if needed)  Register To Reply

##### Users Browsing this Thread

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