Help Excel97 gives incorrect multiplication response

D

DrivenOG

Excel97 gives incorrect multiplication response when Cell location is used
for eample:
Excel says E4*15.22=873.882 (the value in E4 is 57.42)
However, if I input =57.42*15.22 in a singal cell Excel gives the correct
answer.

How can I get Excel to give correct answers when cell locations are used?

(e-mail address removed)
 
C

Chip Pearson

Is the value in E4 the result of a formula? If so, its actual
value may not be 57.42; this might be the rounded displayed
value. With 57.42 in E4, I get 873.932400000000 using E4 and
using 57.42 directly in the formula.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
L

LanceB

....and 873.882/15.22 = 57.41668857

Lance

Chip Pearson said:
Is the value in E4 the result of a formula? If so, its actual
value may not be 57.42; this might be the rounded displayed
value. With 57.42 in E4, I get 873.932400000000 using E4 and
using 57.42 directly in the formula.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
Click to expand...
 

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

Need Help with a VBA subroutine 0
if function help 5
Multiply with Vlookup value from another Worksheet 0
Histogram/Frecuency for Multiple Response Questions 1
Leave final cell blank 2
Scroll does not show preview 0
Problems with using TEXT, INDIRECT and ADDRESS within an array for 10
Cell Range Problem 1

Top