Thread: what is the formula that help when cell=0/cell=0 to be display a .
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Samo Samo is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote