how do i get excel to ignore a value when using formulas
 

i am working with a sheet that someone has set up at work. it works out %age
against sales plan and until the takings cell has been filled in it displas
-100.00. when the chart is then calculating a total over a period of weeks
(average) i have to change the formula. Is there a way that i can get excel
to just ignore the -100.00 when it is caluclating the answer from the sum?

All help would be appreciated

Andy

how do i get excel to ignore a value when using formulas
 

It should be easy but can you show the data and illustrate the problem?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"andy in leeds" <andy in wrote in message
...
i am working with a sheet that someone has set up at work. it works out
%age
against sales plan and until the takings cell has been filled in it
displas
-100.00. when the chart is then calculating a total over a period of weeks
(average) i have to change the formula. Is there a way that i can get
excel
to just ignore the -100.00 when it is caluclating the answer from the sum?

All help would be appreciated

Andy

how do i get excel to ignore a value when using formulas
 

i will send the data to the e-mail address shown when i clicked on your
display name!! password is manchester

"Bob Phillips" wrote:

It should be easy but can you show the data and illustrate the problem?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"andy in leeds" <andy in wrote in message
...
i am working with a sheet that someone has set up at work. it works out
%age
against sales plan and until the takings cell has been filled in it
displas
-100.00. when the chart is then calculating a total over a period of weeks
(average) i have to change the formula. Is there a way that i can get
excel
to just ignore the -100.00 when it is caluclating the answer from the sum?

All help would be appreciated

Andy

how do i get excel to ignore a value when using formulas
 

Hasn't arrived yet.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"andy in leeds" <andy in wrote in message
...
i will send the data to the e-mail address shown when i clicked on your
display name!! password is manchester

"Bob Phillips" wrote:

It should be easy but can you show the data and illustrate the problem?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"andy in leeds" <andy in wrote in
message
...
i am working with a sheet that someone has set up at work. it works
out
%age
against sales plan and until the takings cell has been filled in it
displas
-100.00. when the chart is then calculating a total over a period of
weeks
(average) i have to change the formula. Is there a way that i can get
excel
to just ignore the -100.00 when it is caluclating the answer from the
sum?

All help would be appreciated

Andy

how do i get excel to ignore a value when using formulas
 

ok, i hav changed the e-mail address and resent the data for you

"Bob Phillips" wrote:

Hasn't arrived yet.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"andy in leeds" <andy in wrote in message
...
i will send the data to the e-mail address shown when i clicked on your
display name!! password is manchester

"Bob Phillips" wrote:

It should be easy but can you show the data and illustrate the problem?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"andy in leeds" <andy in wrote in
message
...
i am working with a sheet that someone has set up at work. it works
out
%age
against sales plan and until the takings cell has been filled in it
displas
-100.00. when the chart is then calculating a total over a period of
weeks
(average) i have to change the formula. Is there a way that i can get
excel
to just ignore the -100.00 when it is caluclating the answer from the
sum?

All help would be appreciated

Andy