Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Aug 2001
    Location
    Bloomington, Indiana, USA
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula Assistance (2k) (2K)

    I am trying to create a formula using IF statements to calculate the wages that I pay an employee to verify against our main payroll system. I have created the IF statement, but when I get to a value that is TRUE, the formula returns the text of the formula. I have tried editing out the quotation marks that the formula wizard put in, but then I get an error message saying that there is something wrong with my formula. I have stared at this for hours and cannot figure it out. HELP! A generic sample spreadsheet is attached.

    Thanks for the help
    Greg <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

  2. #2
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Missouri, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Assistance (2k) (2K)

    You have quote marks around that part of the IF statement (treating it like text, not numbers)

    =IF(G3="RGW","+Round(((H2+I2)*(B2*.25)+(J2+K2)*(B2*1.5),2)",+ROUND(((H3+I3)*B3)+(J3+K3)*(B3*1.5),2))

    Should be:

    =IF(G3="RGW",+Round(((H2+I2)*(B2*.25)+(J2+K2)*(B2* 1.5),2),+ROUND(((H3+I3)*B3)+(J3+K3)*(B3*1.5),2))

  3. #3
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Missouri, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Assistance (2k) (2K)

    Also, be sure that you make the change in row 2 and then copy the formula. because if you change onlyrow 6, the references to the proper cells will not be correct.

  4. #4
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Tampico, Tamps, Mexico
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Assistance (2k) (2K)

    maybe, there are another error with the parentheses...

    Try this:
    =IF(G6="RGW",ROUND((H2+I2)*(B2*0.25)+(J2+K2)*(B2*1 .5),2),ROUND(((H6+I6)*B6)+(J6+K6)*(B6*1.5),2))
    or
    =IF(G6="RGW",ROUND(($H$2+$I$2)*($B$2*0.25)+($J$2+$ K$2)*($B$2*1.5),2),ROUND(((H6+I6)*B6)+(J6+K6)*(B6* 1.5),2))

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Assistance (2k) (2K)

    You have 3 parentheses (or bracket signs - depending on your version of English) after the first use of ROUND. There should be only two.

    A tip for future reference: if you put your cursor into the middle of the IF expression inside the Formula Bar, you will find that the parentheses/brackets colour code themselves - making it easier to spot both matching and hierarchy.
    Gre

Posting Permissions

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