From: BVG on 29 Dec 2009 07:11 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.
From: MsExlLearner on 29 Dec 2009 07:43 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!  (MsExlLearner)  "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.
From: Fred Smith on 29 Dec 2009 07:44 =if(a1>500,a1*75%,if(a1>200,a1*50%,a1*25%)) Regards, Fred "BVG" <BVG(a)discussions.microsoft.com> wrote in message news:C24DE901A48945158144226F0953CC8B(a)microsoft.com... > 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.
From: Arvi Laanemets on 29 Dec 2009 09:23 Hi When values in A1 never will be negative or nonnumeric, then =MATCH($A$1,{0;200;500},1)*0.25 When values in A1 may be negative, but the condition 'below 200' applies, then =MATCH($A$1,{999999;200;500},1)*0.25 (replace the 1st member in array (999999) with any of your own. When values in A1 < 0 must return an empty cell or some string, then =IF(ISERROR(MATCH($A$1,{0;200;500},1)),"",MATCH($A$1,{0;200;500},1)*0.25) Arvi Laanemets "BVG" <BVG(a)discussions.microsoft.com> wrote in message news:C24DE901A48945158144226F0953CC8B(a)microsoft.com... > 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.
From: Arvi Laanemets on 29 Dec 2009 09:28 Another solution: =0.25*(($A$1>=0)+($A$1>=200)+($A$1>=500)) When no condition applies, this formula returna 0% PS: In both answers, format the formula cell as percentage! Arvi Laanemets "BVG" <BVG(a)discussions.microsoft.com> wrote in message news:C24DE901A48945158144226F0953CC8B(a)microsoft.com... > 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.

Next

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