Good day all, i have a calculation below which calculates the following,
Cells G - H x E = result should be "0"

G = 2185.79
H = 2185.79
E = 4

However i get a result of -6557.37 ??

ActiveCell.FormulaR1C1 = "=RC[-2]-RC[-1]*RC[-4]"

Could somebody please give me some help with this.

thanks in advance.

Tempy

*** Sent via Developersdex http://www.developersdex.com ***