Hello Everyone!
I'm having trouble with a basic excel calculation.
D E F G H
500.0 46.4 16 11 500.0
Column D & E are figures I'm manually entering.
F has the sum E/2.9
G has the sum =(D1/E1) (no decimal places)
H has the sum =(E1*G1) (1 decimal place)
As you can see the calculation is H is incorrect, any ideas? I feel it is something to do with multiplying the formula in G. If I manually put a figure in G the calculation in H will be correct.
Any thoughts?
Bookmarks