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

[andy in leeds]

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

 

[Bob Phillips]

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]

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

 

[Bob Phillips]

Hasn't arrived yet.

--
HTH

Bob Phillips

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

 

[andy in leeds]

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