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
Bookmarks