Would greatly appreciate it if someone could help me with this error. I am
using Excel 2003.

My formula at the moment is =SUM(C2-B2) / B2 * 100 as i have copied this
formula down the spreadsheet where there is no value in the b column cells I
get the error message #DIV/0!

I have tried the argument =IF(ISERROR(C2/B2),"",C2/B2) but i must not be
using it correctly as i then get an #value error message. Would be grateful
if someone could tell me how to alter my formula so I can get rid of #DIV/0!
message as it looks untidy and I don't want it to print out when I produce a
hard copy.

Many Thanks.

Kindest Regards
Calvina Hayes

I like to use the if function for this problem: ie
"=if(b2="","",sum(c2-b2)/b2*100)", that should fix it.

On May 5, 7:00 pm, Calvina Hayes <Calvina
wrote:
Would greatly appreciate it if someone could help me with this error. I am
using Excel 2003.

My formula at the moment is =SUM(C2-B2) / B2 * 100 as i have copied this
formula down the spreadsheet where there is no value in the b column cells I
get the error message #DIV/0!

I have tried the argument =IF(ISERROR(C2/B2),"",C2/B2) but i must not be
using it correctly as i then get an #value error message. Would be grateful
if someone could tell me how to alter my formula so I can get rid of #DIV/0!
message as it looks untidy and I don't want it to print out when I produce a
hard copy.

Many Thanks.

Kindest Regards
Calvina Hayes

Thank you for your swift reply, problem now fixed.

Have a great day.

Kind Regards
Calvina

" wrote:

I like to use the if function for this problem: ie
"=if(b2="","",sum(c2-b2)/b2*100)", that should fix it.

On May 5, 7:00 pm, Calvina Hayes <Calvina
wrote:
Would greatly appreciate it if someone could help me with this error. I am
using Excel 2003.

My formula at the moment is =SUM(C2-B2) / B2 * 100 as i have copied this
formula down the spreadsheet where there is no value in the b column cells I
get the error message #DIV/0!

I have tried the argument =IF(ISERROR(C2/B2),"",C2/B2) but i must not be
using it correctly as i then get an #value error message. Would be grateful
if someone could tell me how to alter my formula so I can get rid of #DIV/0!
message as it looks untidy and I don't want it to print out when I produce a
hard copy.

Many Thanks.

Kindest Regards
Calvina Hayes

=IF(OR(B2="",B2=0),"",(C2-B2)/B2*100


"Calvina Hayes" wrote:

Would greatly appreciate it if someone could help me with this error. I am
using Excel 2003.

My formula at the moment is =SUM(C2-B2) / B2 * 100 as i have copied this
formula down the spreadsheet where there is no value in the b column cells I
get the error message #DIV/0!

I have tried the argument =IF(ISERROR(C2/B2),"",C2/B2) but i must not be
using it correctly as i then get an #value error message. Would be grateful
if someone could tell me how to alter my formula so I can get rid of #DIV/0!
message as it looks untidy and I don't want it to print out when I produce a
hard copy.

Many Thanks.

Kindest Regards
Calvina Hayes

Thank you very much for your quick reply, this fixed the problem.

Have a great day

Kind Regards
Calvina

"Teethless mama" wrote:

=IF(OR(B2="",B2=0),"",(C2-B2)/B2*100


"Calvina Hayes" wrote:

Would greatly appreciate it if someone could help me with this error. I am
using Excel 2003.

My formula at the moment is =SUM(C2-B2) / B2 * 100 as i have copied this
formula down the spreadsheet where there is no value in the b column cells I
get the error message #DIV/0!

I have tried the argument =IF(ISERROR(C2/B2),"",C2/B2) but i must not be
using it correctly as i then get an #value error message. Would be grateful
if someone could tell me how to alter my formula so I can get rid of #DIV/0!
message as it looks untidy and I don't want it to print out when I produce a
hard copy.

Many Thanks.

Kindest Regards
Calvina Hayes

Sat, 5 May 2007 18:00:00 -0700 from <?B?Q2FsdmluYSBIYXllcw==?
= <Calvina :
Would greatly appreciate it if someone could help me with this error. I am
using Excel 2003.

My formula at the moment is =SUM(C2-B2) / B2 * 100 as i have copied this
formula down the spreadsheet where there is no value in the b column cells I
get the error message #DIV/0!

I have tried the argument =IF(ISERROR(C2/B2),"",C2/B2) but i must not be
using it correctly as i then get an #value error message.

You're making it too hard on yourself. The error condition arises
when B2 is zero, so change your first formula to
=if(B2=0,"",sum(C2-B2)/B2*100)

But there's an additional problem: your sum(C2-B2) doesn't make sense
because you are summing one number. I suspect you messed up some
parentheses somewhere. If you don't see your error, can you tell us a
little more about what you're trying to do?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/