Nov 21 2019 07:28 AM
Good Morning,
I have a formula put together in an excel table that I need help solving. I have a number of cells displaying quantity shipped and another number of cells display quantity defective. I am calculating the percent of defective parts for each column, but because it is possible to have 0 defective parts I have to use an IFERROR message to avoid the DIV0 error. For my percentage I would also like the value to be rounded down so I have come up with the following formula:
=IFERROR(ROUNDDOWN(C51/C50,0),0) in a cell formatted as a percentage.
This works for values above 1, but when the value is less than one I would like it to round down and display 0% instead of displaying a blank cell.
Is there a way to achieve this?
Thanks!
RHenny
Nov 21 2019 07:42 AM