Div/0 to show as 0%

[shanea.kr]

Here is my formula.


=IF($L8=0,0,(D8/'Cooler std. mtrx'!$D$12)+(C8/'Cooler std. mtrx'!$D$11)+(E8/'Cooler std. mtrx'!$D$8)+(F8/'Cooler std. mtrx'!$D$6)+(G8/'Cooler std. mtrx'!$D$5)+(H8/'Cooler std. mtrx'!$D$10)+(I8/'Cooler std. mtrx'!$D$9)+(J8/'Cooler std. mtrx'!$D$6))/$K8

Where L8 is Work hours. This equation is showing the productivity where D8, C8, etc is the work type/ how many each worker should be able to do.

I need it to show 0% if there are no work hours rather than the div/0 error.

Thank you.

[Søren Larsen]

Try:

=IFERROR(IF($L8=0,0,(D8/'Cooler std. mtrx'!$D$12)+(C8/'Cooler std. mtrx'!$D$11)+(E8/'Cooler std. mtrx'!$D$8)+(F8/'Cooler std. mtrx'!$D$6)+(G8/'Cooler std. mtrx'!$D$5)+(H8/'Cooler std. mtrx'!$D$10)+(I8/'Cooler std. mtrx'!$D$9)+(J8/'Cooler std. mtrx'!$D$6))/$K8,0)

[shanea.kr]

I did. It is saying that there are too many arguments for this function

[Søren Larsen]

Is your original formula working? If yes, then try:

=IFERROR(your formula here,0)

[shanea.kr]

Awesome worked perfectly. Thank you!!!

[Søren Larsen]

No problem!