# Excel multiplication

1. ## 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?

2. ## Re: Excel multiplication

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

3. ## Re: Excel multiplication

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)

4. ## Re: Excel multiplication

Perfect thank you!

5. ## Re: Excel multiplication

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1