Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Zero Division
Can't remember the formula for not showing DIV/? error message when dividing
by zero |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Zero Division
Something along the lines of
=IF(B1<0, A1/B1,"") or =IF(ISERR(A1/B1),"",A1/B1) -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) "Beep Beep" wrote in message ... Can't remember the formula for not showing DIV/? error message when dividing by zero |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Zero Division
On Mar 11, 5:18*pm, Beep Beep
wrote: Can't remember the formula for not showing DIV/? error message when dividing by zero Hi, You can have the catch all solution of =if(iserror(your formula),"",your formula) but this hides lots of errors so depending on your formula a better solution may be to check for zero =IF(A1=0,"",B1/A1) which doesn't hide other errors Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Division | Excel Discussion (Misc queries) | |||
Division | Excel Worksheet Functions | |||
Need help with division, please!!! | Excel Worksheet Functions | |||
Division help? | Excel Discussion (Misc queries) | |||
Division By Zero | Excel Worksheet Functions |