If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#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
|
|||
|
|||
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help again from Ken Snell (Query) | Randy | Running & Setting Up Queries | 22 | August 29th, 2005 08:15 PM |
Formula Help | Diana HIgh School | General Discussion | 6 | November 18th, 2004 05:19 AM |
Outlook Express is slow | ava cohen | Outlook Express | 18 | August 27th, 2004 12:17 AM |
msimn.exe-Application error message | Blondenblue_uk | Outlook Express | 2 | July 23rd, 2004 01:03 PM |
trying to gain access to emails on old hard disk | wilfred | Outlook Express | 2 | July 13th, 2004 11:35 AM |