Excel multiplication

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?

Even if you display the results of those calculations as integers, the underlying values are still fractional. You need to change the formulae as follows:

F1: =ROUND(E1/2.9,0)

G1: =ROUND(D1/E1,0)

H1: =ROUND(E1*G1,1)

Hope this helps.

Pete

If by G you mean it is integer, then yes it is wrong but i suspect you have G formatted to show 0 decimal places so it "appears" to be 11 whereas it is actually 10.7759 ( to 4 decimal places).

If really want G to be 11 then use =ROUND(D1/E1)

Perfect thank you!

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete