| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display formula on the cell | Excel Worksheet Functions | |||
| Display cell ref for MAX formula | Excel Discussion (Misc queries) | |||
| Formula won't display as cell set to Constant | Excel Discussion (Misc queries) | |||
| Display formula in cell | Excel Discussion (Misc queries) | |||
| Shortcut key to display change the display from displaying cell values to cell formulae | Excel Programming | |||
Linear Mode
