Re: How can I create a formula using 2 %'s for 2 sets of ages in the .

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Roger Govier (roger_at_technologyNOSPAM4u.co.uk)
Date: 03/03/05

Next message: Kassie: "RE: Formula help"
Previous message: Chris Short: "Re: Formatting 100's and 1000's"
In reply to: AB: "How can I create a formula using 2 %'s for 2 sets of ages in the ."
Messages sorted by: [ date ] [ thread ]

Date: Thu, 3 Mar 2005 06:12:49 -0000

Do you mean something like - If age <50 multiply age by 60% otherwise
multiply by 70%?
If so, then with age in say cell A1
=IF(A1<=50,A1*60%,A1*70%)

-- 
Regards
Roger Govier
"AB" <AB@discussions.microsoft.com> wrote in message 
news:EC4774D2-DF93-412F-A7DC-6829D1713024@microsoft.com...
>I am putting together a sp[read*** which has to calculate a range of ages
> by one % and then another range of ages to another %?
>
> Please help

Next message: Kassie: "RE: Formula help"
Previous message: Chris Short: "Re: Formatting 100's and 1000's"
In reply to: AB: "How can I create a formula using 2 %'s for 2 sets of ages in the ."
Messages sorted by: [ date ] [ thread ]