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 |