I have a progress sheet I use to track the quantity of insulation installed.
My current formula in Q12 is this: =IF(J12>0,L12/J12,0)
Its telling me if the estimated quantity in J12 is greater than zero, then divided the quantity installed to date (L12) by the estimated quantity (J12)....which then produces me a percentage complete.
If the workers exceed the quantity installed to date my percentage complete will then exceed 100%...so I have line items showing 223%...and 132%...I need those to max out at 100%
I would like the formula to still do what its doing now BUT make the percent complete MAX OUT at 100%.....so even if they exceed the estimated quantity, the cell the formula is in will not go above 100%
Can someone please help me out?
My current formula in Q12 is this: =IF(J12>0,L12/J12,0)
Its telling me if the estimated quantity in J12 is greater than zero, then divided the quantity installed to date (L12) by the estimated quantity (J12)....which then produces me a percentage complete.
If the workers exceed the quantity installed to date my percentage complete will then exceed 100%...so I have line items showing 223%...and 132%...I need those to max out at 100%
I would like the formula to still do what its doing now BUT make the percent complete MAX OUT at 100%.....so even if they exceed the estimated quantity, the cell the formula is in will not go above 100%
Can someone please help me out?