K
kilroy
I could use some help in creating a statement that avoids the div/
error in the following formula
=SUM(((G4/G40)*J40)+((L4/G4)*J42)+((Q4/G41)*J41))
at any point G4,L4,Q4 could be a value of 0. G40,J40,J42,G41,J4
always have values.
I'd like the cell to show a value of 0 when there are not any value
for G4,L4,Q4
THANKS
error in the following formula
=SUM(((G4/G40)*J40)+((L4/G4)*J42)+((Q4/G41)*J41))
at any point G4,L4,Q4 could be a value of 0. G40,J40,J42,G41,J4
always have values.
I'd like the cell to show a value of 0 when there are not any value
for G4,L4,Q4
THANKS