Excel produces wrong answer when trying to work out a percentage?

I

ian99121

using the formula "=D6*G6/100" to find a percentage gives a different answer
to typing in the numbers rather than using references. the sum should be
=28000*18/100 which gives the correct answer of 5040 which is 18% of 28000,
however the figure excel delivers is 4911? please help.
 
J

Jerry W. Lewis

The numbers in D6 and G6 are not exacty 28000 and 18. Format to show more
decimal places, or else use the formulas
=D6&""
and
=G6&""
to force a display of the full cell contents.

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get percentage of whole 2
Calculator Answer Doesn't Match Excel Answer 3
Subtracting gives the wrong answer!! 2
Trying to get a Boolean formula to work month-to-month 4
Excel Excel help please 1
Avoiding a circular reference or value error while trying to calculate commission - a challange for 4
Percentage to work out bonuses and penalty's 1
EXCEL ANSWER TO FORMULA DOES NOT SHOW UP 10

Top