Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV/0! message
I am trying to create a formula for a percentage whereby the #DIV/0! does not appear if the cell is left blank or is not calcuable. I can work it out for a percentage change using the following : =IF(C14=0,"not calculable",(C14-B14)/B14) but I want it to work for example e4/d14 with values in d being 0 and e being 1, then i get #DIV/0! and also if the cells are left blank. Any suggestions? -- rjc_29 ------------------------------------------------------------------------ rjc_29's Profile: http://www.excelforum.com/member.php...fo&userid=3475 View this thread: http://www.excelforum.com/showthread...hreadid=501635 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
#DIV/0! message
Try
=IF(B14=0,"",IF(C14=0,"not calculable",(C14-B14)/B14)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "rjc_29" wrote in message ... I am trying to create a formula for a percentage whereby the #DIV/0! does not appear if the cell is left blank or is not calcuable. I can work it out for a percentage change using the following : =IF(C14=0,"not calculable",(C14-B14)/B14) but I want it to work for example e4/d14 with values in d being 0 and e being 1, then i get #DIV/0! and also if the cells are left blank. Any suggestions? -- rjc_29 ------------------------------------------------------------------------ rjc_29's Profile: http://www.excelforum.com/member.php...fo&userid=3475 View this thread: http://www.excelforum.com/showthread...hreadid=501635 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I control where the input message appears? | Excel Discussion (Misc queries) | |||
Adding an error message at close of file when criteria are met | Excel Discussion (Misc queries) | |||
Check box and and formula | Excel Discussion (Misc queries) | |||
Getting an error message "Cannot shift objects off of sheet" | Excel Discussion (Misc queries) | |||
changing the message in an error message | Excel Worksheet Functions |