Problem Formula

[Eintsein_mc2]

Hi Guys, I have this formula =IF(G22="","",(H22+I22)*G22) What I use it
for is to add two different prices together then they get multiplied by
the amount entered into a cell. eg, H22=$2.24, I22=$0.52 and if I enter
1 into G22 it equals $2.76, which is correct. But if I enter a figue of
1800 into G22 I get a figue of $4961.42 when it should be $4968.00. Any
help for this novice would be great. Thanks

 

[Alan]

Are the values in H22 and I22 the results of formulas? If so its probably a
rounding issue where for example 2.236458 is displayed as 2.24 but the
actual value is still 2.236458, try
=IF(G22="","",ROUND((H22+I22),2)*G22)
Regards,
Alan.

 

[Eintsein_mc2]

Thanks Alan, you are right they are the results of formulas. Before I
asked for help I tried adding "ROUND" to the fomula but could not get
it to work. After looking at your formula I know why, Thanks for your
help.
Regards,
Simon

 

[Alan]

Your welcome, BTW it can be simplified to
=IF(G22="","",ROUND(H22+I22,2)*G22)
Regards,
Alan.