Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PRODUCT RESULTS/VALUE ARE NOT CALCULATING CORRECTLY
I am having trouble understanding the reason for why my product
results/values are not calculating correctly. What the results are on the excel sheet is different from when I will calculate it on the calculator. I.E.: say I have the value of $0.08(price per piece) in colum E140 and then the amount of 808 (number of pieces) in colum I140, therefore I will then place the formula of =product(E140)*(I140) and it will then give me the result of 64.73. Which if I calculated that on the calculator it would give me the result of 64.64, which is a difference of .09 cents. I am finding that it is happening in more then one rows. I even tried to use a differnet formula, but I will still end up with the same result. Is there any ideas on how I can rectify this issue or will I have to start on a fresh sheet? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PRODUCT RESULTS/VALUE ARE NOT CALCULATING CORRECTLY
Is the price cell a calculated value?
If I manually enter 0.08 in E140 and 808 in I140 then do: =E140*I140 The result is 64.64 So, either the price cell or the quantity cell (or both) is calculated and is really greater than what's being displayed. You could try this: =ROUND(E140,2)*I140 Biff "EnergyMuse" wrote in message ... I am having trouble understanding the reason for why my product results/values are not calculating correctly. What the results are on the excel sheet is different from when I will calculate it on the calculator. I.E.: say I have the value of $0.08(price per piece) in colum E140 and then the amount of 808 (number of pieces) in colum I140, therefore I will then place the formula of =product(E140)*(I140) and it will then give me the result of 64.73. Which if I calculated that on the calculator it would give me the result of 64.64, which is a difference of .09 cents. I am finding that it is happening in more then one rows. I even tried to use a differnet formula, but I will still end up with the same result. Is there any ideas on how I can rectify this issue or will I have to start on a fresh sheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Product Selection order form | Excel Worksheet Functions | |||
why isn't this formula calculating correctly? | Excel Discussion (Misc queries) | |||
figure out why this formula isn't calculating correctly | Excel Discussion (Misc queries) | |||
Formulas not calculating correctly | Excel Discussion (Misc queries) | |||
Which function(s)? | Excel Worksheet Functions |