what is the formula that help when cell=0/cell=0 to be display a .

[Guest]

at the excel if b1 = 0 , b2 = 0 , and b3 formula is =(b1)/sum(b1:b2) it
display at b3 " #div/0!" i need a formula replace " #div/0!" at b3 with
number "100"
please help

 

[Samo]

Try ...

=IF(ERROR.TYPE(B1/SUM(B1:B2))=2,100,B1/SUM(B1:B2))

Check your Excel Help for error.type or iserror functions for more
details.

Samo

 

[Bob Phillips]

=IF(SUM(B1:B2)=0,100,B1/SUM(B1:B2))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Chip Pearson]

This formula is wrong. ERROR.TYPE is used for cells that already
have an error. If there is no error, ERROR.TYPE will itself
return an N/A error.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


in message
news:[email protected]...

 

[Samo]

when you divide any number by 0 you get an error of "#DIV/0!", so an
error exists and therefore you can use the Error.type formula.

Samo

 

[Bob Phillips]

yeah, but what happens when you don't divide by zero?