LinkBack URL
About LinkBacks
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")
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")
Last edited by Jim15; 07-23-2013 at 05:38 PM.
Jim15
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.
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.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks