Need help replacing #DIV/0! from a SUM, with the value from another field

[Pinxy]

In other words, when a sum returns the value #DIV/0!, I want to then have the value of another field placed in that cell.

My formula
=SUM(S17*C17)/K17

I want to replace the calculated value #DIV/0! with the value in cell G17

Where
S17=2
C17=11
K17=0
G17=7

[Jonmo1]

Try

=S17*C17/IF(K17=0,G17,K17)

[Pinxy]

Thanks - That does not return the error, but it fills the cell with the value '3' which is not the value in G17. ?

[Ace_XL]

=IFERROR(SUM(S17*C17)/K17,G17)
or
=IF(ISERROR(SUM(S17*C17)/K17),G17,SUM(S17*C17)/K17)



EDIT: the SUM function is redundant and can be done away with..
hence,
=IFERROR(S17*C17/K17,G17)
or
=IF(ISERROR(S17*C17/K17),G17,S17*C17/K17)

[Jonmo1]

OH, OK..

I thought you wanted to devide the result of S17*C17 by K17 (or G17 if K17 is 0)...

Try

=IF(K17=0,G17,S17*C17/K17)

[Pinxy]

That did it! Thanks so much - have a great week!

[Pinxy]

Thanks for the heads up about the sum function. Excel novice here. Got the problem solved in record time with help from this forum though!

[Pinxy]

Problem solved. Thanks Jonmo1 and Ace_XL!

[Jonmo1]

You're welcome.