# Modify statement to post a zero (0) in the cell when variable = 0 in the equation?

1. ## Modify statement to post a zero (0) in the cell when variable = 0 in the equation?

How would I modify the following statement to post a zero (0) in the cell when C78 = 0?

=IFERROR(SUM(C77^\$C\$6*(C77^(1-\$C\$6)-C78^(1-\$C\$6))/(D78*(1-\$C\$6))),"0")  Register To Reply

2. ## Re: Modify statement to post a zero (0) in the cell when variable = 0 in the equation?

The easiest way I see it working is test for that condition. If c78 = 0, then show 0, else do the calculation as desired.

Formula:  `Please Login or Register  to view this content.`

EDIT: If I could spell the world will be in sooo much trouble.  Register To Reply

3. ## Re: Modify statement to post a zero (0) in the cell when variable = 0 in the equation?

Are you sure you want to quote that 0?

Quoting numbers turns them into TEXT values which could lead to problems if you do other calculations on the result of this formula.  Register To Reply