Forum Discussion
justin williammee
Feb 23, 2018Copper Contributor
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.
...
Haytham Amairah
Feb 23, 2018Silver Contributor
Justin,
Use this formula in column F:
=ROUND(D2*E2,1)
Ria Pia
Feb 23, 2018Copper Contributor
Yes, I was having the same issue. Resolved!
Thank You!
Thank You!