Formula capping percentage @ 100%

[jbashir]

Hi i am trying to use a formula to calculate fulfillment but need to cap at 100%

there are also blank cells in the data set needing the Iferror formula, I cant seem to work out how to add in the if >100 return 100% after the initial calculation.

the formula looks like this so far and is working fine just need to add in the part to replace outcomes over 100%

=iferror(sum(H2/(F2+G2+I2)),1)

thanks in advance,

 

[Canapone]

Hi,

just an attempt. I'd prefer to try on a sample file.

=iferror(min(1,sum(H2/(F2+G2+I2))),1)

Hope that helps

 

[jbashir]

worked like a dream, thank you very much