Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula for excel sheet.
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula for excel sheet.
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula for excel sheet.
=if(a1500,a1*75%,if(a1200,a1*50%,a1*25%))
Regards, Fred "BVG" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula for excel sheet.
Hi
When values in A1 never will be negative or non-numeric, 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" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula for excel sheet.
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" wrote in message ... 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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Build a sheet name in an Excel formula | Excel Worksheet Functions | |||
need help on excel sheet formula | Excel Worksheet Functions | |||
How to put VBA formula in Excel Sheet | New Users to Excel | |||
Is there a formula which will print the sheet name in Excel? | Excel Discussion (Misc queries) | |||
Can't get a formula to work in each row of an Excel sheet. | Excel Worksheet Functions |