formula for excel sheet.
.... 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*7 5%)))
--
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.
|