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! Error
Hi
I get an error (#DIV/0!) when I divide one cell by the other and there are no entries in the cells. How can i get the folrmula to surpress the error (show a blank cell) when there are no entries in the cells that the formula refers to? Could you please provide an example Thanks John |
#2
|
|||
|
|||
=IF(B1=0,"",A1/B1)
-- HTH Bob Phillips "Joohn Calder" wrote in message ... Hi I get an error (#DIV/0!) when I divide one cell by the other and there are no entries in the cells. How can i get the folrmula to surpress the error (show a blank cell) when there are no entries in the cells that the formula refers to? Could you please provide an example Thanks John |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can I prevent a #DIV/0! error from plotting on a chart | curious | Charts and Charting | 1 | August 26th, 2005 08:35 AM |
Help! I'm getting error messages too much-can't open Resume Wizard | LizLB | General Discussion | 0 | May 3rd, 2005 01:46 AM |
Help, i'm gettiing error: Access has encountered a problem and needs to close... | betsy | General Discussion | 0 | September 14th, 2004 08:20 PM |
INSERT query inside an error handler? | Richard Hollenbeck | Running & Setting Up Queries | 7 | September 11th, 2004 02:31 PM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |