# Thread: Formula Assistance (2k) (2K)

1. ## 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

2. ## 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. ## 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. ## 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. ## 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.

#### Posting Permissions

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