Disabling formula
 

i am creating a termly spreadsheet to calculate children,s point score. If a
child joins us during the spring term I want it's score to be included in
that term but not in the earlier autumn term. I want therefore to disable the
formula in the autumn term calculation but let the remaining formula WORK. I
DON'T WANT TO PASTE THE VALUE OVER THE TOP BECAUSE I will need the formula to
work again next year as this is a running record... eek any help would be
very much appreciated... smile
Melanie oops sorry about the misplaced capitals!!

Disabling formula
 

Melanie

Could you wrap your formula in an IF and use the start date of the child,
e.g.

=IF(StartDateOfChildEndOfAutumnTerm,JustTakeSprin gCalc,TakeSumOfSpringAndAutumn)

You would code the end of autumn term in another cell so you could just
update this next year.

Does that make sense?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk





"Mel D" <Mel wrote in message
...
i am creating a termly spreadsheet to calculate children,s point score.
If a
child joins us during the spring term I want it's score to be included in
that term but not in the earlier autumn term. I want therefore to disable
the
formula in the autumn term calculation but let the remaining formula WORK.
I
DON'T WANT TO PASTE THE VALUE OVER THE TOP BECAUSE I will need the formula
to
work again next year as this is a running record... eek any help would be
very much appreciated... smile
Melanie oops sorry about the misplaced capitals!!

Disabling formula
 

You can convert the formula to text, thus disabling it, by inserting an
apostrophe before the opening = character.

-------------------------------------------------------
"Mel D" wrote:

i am creating a termly spreadsheet to calculate children,s point score. If a
child joins us during the spring term I want it's score to be included in
that term but not in the earlier autumn term. I want therefore to disable the
formula in the autumn term calculation but let the remaining formula WORK. I
DON'T WANT TO PASTE THE VALUE OVER THE TOP BECAUSE I will need the formula to
work again next year as this is a running record... eek any help would be
very much appreciated... smile
Melanie oops sorry about the misplaced capitals!!