T
Tempy
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 ***
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 ***