software

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,quot;not calculablequot;,(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: www.excelforum.com/member.php...foamp;userid=3475
View this thread: www.excelforum.com/showthread...hreadid=501635Try

=IF(B14=0,quot;quot;,IF(C14=0,quot;not calculablequot;,(C14-B14)/B14))--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

quot;rjc_29quot; gt;
wrote in message
...
gt;
gt; I am trying to create a formula for a percentage whereby the
gt; #DIV/0!
gt; does not appear if the cell is left blank or is not calcuable.
gt;
gt; I can work it out for a percentage change using the following :
gt;
gt; =IF(C14=0,quot;not calculablequot;,(C14-B14)/B14)
gt;
gt;
gt; but I want it to work for example e4/d14 with values in d being
gt; 0 and e
gt; being 1, then i get #DIV/0!
gt;
gt; and also if the cells are left blank.
gt;
gt; Any suggestions?
gt;
gt;
gt; --
gt; rjc_29
gt; ------------------------------------------------------------------------
gt; rjc_29's Profile:
gt; www.excelforum.com/member.php...foamp;userid=3475
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=501635
gt;