If/Greater than & less than Formula assistance
Hi John,
you are right instead of 0.75 should be 0.075
"John C" wrote:
Assuming all your multiplied values should have been percentages, and your
first one, 0.75, should have been 0.075 (and %, so 0.075%).
--
** John C **
"Eduardo" wrote:
Hy Kdeyton, try this it works for me
+IF(AND(A1=15000,A1<=22000),A1*0.75,IF(AND(A1=22 001,A1<=25000),A1*1.25,IF(AND(A1=25001,A1<=30000) ,A1*1.5,IF(AND(A1=30001,A1<=35000),A1*1.75,IF(AND (A1=35001,A1<=40000),A1*2,IF(A1=40001,A1*2.5,0)) ))))
You can enter the variables in cells and refer it in the formula instead of
entering the values in the formula in that case if you want to change your
parameters it will automatically change it
"kdeyton" wrote:
I have been trying for hours to enter a formula that will allow me to do the
following:
If cell A1 is Between 15000 and 22000 than A1 times .075%
If cell A1 is Between 22001 and 25000 than A1 times 1.25%
If cell A1 is Between 25001 and 30000 than A1 times 1.5%
If cell A1 is Between 30001 and 35000 than A1 times 1.75%
If cell A1 is Between 35001 and 40000 than A1 times 2%
If cell A1 is 40001 and above than A1 times 2.5%
Please Help, I need to your assistance so I can move on with the rest of my
day!
Thank you in advance!
|