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.
...
Hi Justin,
It's unusual to have a data in a column have mixed formats!
The data in a column is supposed to carry one format based on the data type.
I recommend you to rearrange the dataset somehow to separate each data type in a separate column.
However, in this unusual case, I hope this formula works well:
=IF(OR(CELL("format",D2)="G",CELL("format",D2)="F2",CELL("format",D2)="P2"),D2*E2,ROUND(D2*E2,1))
Thank you for the reply, however I was able to make it work by using your original formula in column D
now the column D formula is =round(C/B,2)
that fixed all the cells that were dependent on the answer in column D.
now the column D formula is =round(C/B,2)
that fixed all the cells that were dependent on the answer in column D.