|
| 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
October 4th, 2005, 12:38 AM
|
|||
|
|||
#DIV/0! Error
Hi,
In the formula listed below sometimes I put zeroes in the 2 cells or I leave them blank but I get the #DIV/0! error. How can I add the ISError function to my formula. Its driving me crazy. =SUM(B14-C14)/B14 Thanks In advance. Kenny 
|
|
#2
October 4th, 2005, 12:56 AM
|
|||
|
|||
|
Firstly, you do not need SUM. This is used in formulas such as SUM(A1:A100)
to sum a range. You need just = (B14-C14)/B14 But if B14 is zero you will get DIV error So =IF(B140,(B14-C12)/B14,"Zero value in B14") best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Kenny16301 via OfficeKB.com" u14535@uwe wrote in message news:554edbdf1ad94@uwe... Hi, In the formula listed below sometimes I put zeroes in the 2 cells or I leave them blank but I get the #DIV/0! error. How can I add the ISError function to my formula. Its driving me crazy. =SUM(B14-C14)/B14 Thanks In advance. Kenny
|
|
#3
October 4th, 2005, 03:21 AM
|
|||
|
|||
|
Another one is use formula as below:
=if(iserror(SUM(B14-C14)/B14), "", SUM(B14-C14)/B14) "Bernard Liengme" wrote: Firstly, you do not need SUM. This is used in formulas such as SUM(A1:A100) to sum a range. You need just = (B14-C14)/B14 But if B14 is zero you will get DIV error So =IF(B140,(B14-C12)/B14,"Zero value in B14") best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Kenny16301 via OfficeKB.com" u14535@uwe wrote in message news:554edbdf1ad94@uwe... Hi, In the formula listed below sometimes I put zeroes in the 2 cells or I leave them blank but I get the #DIV/0! error. How can I add the ISError function to my formula. Its driving me crazy. =SUM(B14-C14)/B14 Thanks In advance. Kenny
|
| 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 |
Linear Mode
