Excel estimate form.xlsx
See attached file:
In the unit cost column, some items need to display with two decimals and others with no decimals.
These are often changing back and forth depending on the item being sold or built
I need a function that will make sure the math stays accurate in the base cost column regardless of 2 decimals or zero decimals
Is it possible to use an "IF" function that decides what rounding to use based on the number of decimal places present, or is there a better way to accomplish this?
I would like to use one formula that covers both scenarios.
Thanks in advance for any help that can be provided!
Bookmarks