I have a formula that has no value, then the result shows me division/0.
How can I make a IF (formula has no value or equal to zero) print zero
I have a formula that has no value, then the result shows me division/0.
How can I make a IF (formula has no value or equal to zero) print zero
Hi,
try this
=iferror("use your formula in this space",0)
Punnam
Or base something on this
Example, formula is A1/B1
=IF(B1=0,0,A1/B1)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
=C136/(C136+D136+E136+F136)
My Answer becomes> #division/0
Should it be this, does not work for me, still error.
=IFERROR(C136/(C136+D136+E136+F136),0)
thanks for your replies,
=if((c136+d136+e136+f136)=0,0,c136/(c136+d136+e136+f136))
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
just for shortness
=C136/sum(C136:F136))
=iferror(C136/sum(C136:F136),0) should work what do you get as a result
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
thanks Sir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks