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.