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