|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 9th, 2005, 02:57 AM
|
|||
|
|||
calculator Errors
When I enter an equation in c1 such as: =product(a1,b1), when a1 is 1000 and
b1 is .10, the answer in c1 should be 100, but it comes out to 102.04. Why? please help. Thank you, Kat 
|
|
#2
October 9th, 2005, 03:19 AM
|
|||
|
|||
|
Quite possibly because B1 is actually 0.10204 but is set to display only 2
decimal places. -- Vasant "Kat and the Calculator" wrote in message ... When I enter an equation in c1 such as: =product(a1,b1), when a1 is 1000 and b1 is .10, the answer in c1 should be 100, but it comes out to 102.04. Why? please help. Thank you, Kat
|
|
#3
October 9th, 2005, 03:21 AM
|
|||
|
|||
|
Hi!
Are the values in either A1 or B1 calculated? I suspect a rounding issue where the displayed value is not the true underlying value.. Try this and see what you get: =PRODUCT(ROUND(A1,0),ROUND(B1,2)) Biff "Kat and the Calculator" wrote in message ... When I enter an equation in c1 such as: =product(a1,b1), when a1 is 1000 and b1 is .10, the answer in c1 should be 100, but it comes out to 102.04. Why? please help. Thank you, Kat
|
|
#4
October 9th, 2005, 04:13 AM
|
|||
|
|||
|
thank you both, you were right. now i can sleep.
"Biff" wrote: Hi! Are the values in either A1 or B1 calculated? I suspect a rounding issue where the displayed value is not the true underlying value.. Try this and see what you get: =PRODUCT(ROUND(A1,0),ROUND(B1,2)) Biff "Kat and the Calculator" wrote in message ... When I enter an equation in c1 such as: =product(a1,b1), when a1 is 1000 and b1 is .10, the answer in c1 should be 100, but it comes out to 102.04. Why? please help. Thank you, Kat
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
