Prev: In Excel can sheet tabs be placed along a side margin?
Next: Error with Copy function
From: "David Biddulph" groups [at] on 29 Dec 2009 10:04
.... but having tested for A1<200 you don't then need to test for A1>=200,
and similarly for 500.

=IF(AND(A1>=0,A1<200),A1*25/100,IF(AND(A1>=200,A1<500),A1*50/100,IF(A1>=500,A1*75/100,"")))
can be simplified to
=IF(A1<0,"",IF(A1<200,A1*25%,IF(A1<500,A1*50%,A1*75%)))
--
David Biddulph


Ms-Exl-Learner wrote:
> Paste this formula in A2 cell
>
> =IF(AND(A1>=0,A1<200),A1*25/100,IF(AND(A1>=200,A1<500),A1*50/100,IF(A1>=500,A1*75/100,"")))
>
> Remember to Click Yes, if this post helps!
>
> --------------------
> (Ms-Exl-Learner)
> --------------------
>
>
> "BVG" wrote:
>
>> Hi,
>> I want to use a formula in excel as below described.
>>
>> i want a formula value in Cell A2.b In Cell A1 is value say if it
>> is $ 500 or above then the A2 should be 75% of A1, if A2 is
>> between 200 to 500 then A2 should be 50%, if A1 is below 200 then A2
>> should be 25% of A1, so please help me out - thanks in advance.


First  |  Prev  | 
Pages: 1 2
Prev: In Excel can sheet tabs be placed along a side margin?
Next: Error with Copy function