Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Curing #DIV/0!????
Hi, Can anyone tell me how to cure the div/o fault on my spread sheet when no value is found......just to tidy things up? Thanks, Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=396012 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Curing #DIV/0!????
Use iserror eg
=if(iserror(a1/b1),"",a1/b1) Regards Rowan "Simon Lloyd" wrote: Hi, Can anyone tell me how to cure the div/o fault on my spread sheet when no value is found......just to tidy things up? Thanks, Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=396012 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Curing #DIV/0!????
=if(denom=0,"Zero Denominator",numer/denom)
Where denom is the range of the denominator and numer is the range of the numerator -- http://HelpExcel.com 1-888-INGENIO 1-888-464-3646 x0197758 "Simon Lloyd" wrote: Hi, Can anyone tell me how to cure the div/o fault on my spread sheet when no value is found......just to tidy things up? Thanks, Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=396012 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Curing #DIV/0!????
Simon,
Either test for the 0 value first [=IF(Whatever=0,,,,,] or test the result for the error [=IF(ISERROR(Whatever),,,, NickHK "Simon Lloyd" wrote in message ... Hi, Can anyone tell me how to cure the div/o fault on my spread sheet when no value is found......just to tidy things up? Thanks, Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=396012 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Curing #DIV/0!????
Thanks for your replies, Rowan's reply seemed the most straight forward (i'm on nights and brain isnt working too well!) the only problem i have now is that if i use that formula all my percentages now show as a decimal i.e 3% is now 0.0314. Is there a tweak for this? Thanks again, Simon. -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=396012 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Curing #DIV/0!????
Have you formatted the cells as Percentage?
"Simon Lloyd" wrote: Thanks for your replies, Rowan's reply seemed the most straight forward (i'm on nights and brain isnt working too well!) the only problem i have now is that if i use that formula all my percentages now show as a decimal i.e 3% is now 0.0314. Is there a tweak for this? Thanks again, Simon. -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=396012 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Curing #DIV/0!????
If it is simply to pretty up the look rather than to remove the fault try
a conditional format formula is =ISERROR(A1) and set the format so the text matches the background colour. hth RES |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Curing #DIV/0!????
Sorry to all! As i said brain isnt working!!! ..........format cells!........it was no brainer! Simo -- Simon Lloy ----------------------------------------------------------------------- Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670 View this thread: http://www.excelforum.com/showthread.php?threadid=39601 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Laser Skin Treatment – A Popular Way Of Curing Various Skin Problems | Excel Worksheet Functions | |||
curing the blocking of cells. | Excel Discussion (Misc queries) |