# Problem Inserting Round function into an IF function

1. ## Problem Inserting Round function into an IF function

I am currently creating a vacation calculator for my territory and am stuck on a formula. I am trying to calculate how much vacation someone has after a certain amount of time in the company. This is what I currently have =IF(A10<1,A10*10,IF(A10<5,10,IF(A10<15,15,IF(A10<25,20,IF(A10>25,25)))))

The problem I am having is the first part =IF(A10<1,A10*10

I need the number that A10*10 give me to round down in cell A12. How do I insert that into the above formula?

Thanks so much,

Ash  Register To Reply

2. ## Re: Problem Inserting Round function into an IF function

Try this:

=IF(A10<1,ROUNDDOWN(A10*10,0),IF(A10<5,10,IF(A10<15,15,IF(A10<25,20,IF(A10>25,25)))))

Hope this helps.

Pete  Register To Reply

3. ## Re: Problem Inserting Round function into an IF function

THANK YOU THANK YOU THANK YOU!!!

That did the trick!!!  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