Forum Discussion
excel not calculating money correctly
In my workbook I have the following columns
A , B , C , D , E , F ,
Item, Qty/ case, Cost/ case, Cost/ unit, # items sold, COGS.
...
Justin,
Use this formula in column F:
=ROUND(D2*E2,1)
That kind of worked. so now my 10 twix now show as 5.70.
however now I have items that are, for example, showing .62 cents ea. and 2 sold and column F is showing 1.20 instead of 1.24. I changed the formula from
=round(D2*E2,1) to =round(D2*E2,2) and then it showed 1.24. However, I would like it if i didn't have to adjust each formula in column F to show the correct amount as there are 115 items or rows that i am calculating info for. Is there another method?
however now I have items that are, for example, showing .62 cents ea. and 2 sold and column F is showing 1.20 instead of 1.24. I changed the formula from
=round(D2*E2,1) to =round(D2*E2,2) and then it showed 1.24. However, I would like it if i didn't have to adjust each formula in column F to show the correct amount as there are 115 items or rows that i am calculating info for. Is there another method?