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" wrote in message
oups.com...
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