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

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

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

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


--
Samo
------------------------------------------------------------------------
Samo's Profile: http://www.excelforum.com/member.php...o&userid=34413
View this thread: http://www.excelforum.com/showthread...hreadid=541894

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

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Mangawy" wrote in message
...
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

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

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


"Samo" wrote
in message
...

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


--
Samo
------------------------------------------------------------------------
Samo's Profile:
http://www.excelforum.com/member.php...o&userid=34413
View this thread:
http://www.excelforum.com/showthread...hreadid=541894

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

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


--
Samo
------------------------------------------------------------------------
Samo's Profile: http://www.excelforum.com/member.php...o&userid=34413
View this thread: http://www.excelforum.com/showthread...hreadid=541894

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

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

"Samo" wrote in message
...

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


--
Samo
------------------------------------------------------------------------
Samo's Profile:
http://www.excelforum.com/member.php...o&userid=34413
View this thread: http://www.excelforum.com/showthread...hreadid=541894