+ Reply to Thread
Results 1 to 3 of 3

Problem Inserting Round function into an IF function

  1. #1
    Registered User
    Join Date
    01-11-2013
    Location
    Tennessee
    MS-Off Ver
    Excel 2003
    Posts
    31

    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

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    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

  3. #3
    Registered User
    Join Date
    01-11-2013
    Location
    Tennessee
    MS-Off Ver
    Excel 2003
    Posts
    31

    Re: Problem Inserting Round function into an IF function

    THANK YOU THANK YOU THANK YOU!!!

    That did the trick!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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