Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help Excel97 gives incorrect multiplication response
|
#2
|
|||
|
|||
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 "DrivenOG" wrote in message ... 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? |
#3
|
|||
|
|||
....and 873.882/15.22 = 57.41668857
Lance "Chip Pearson" wrote: 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 "DrivenOG" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|