K
knight
I want create formula, =IF A1<100*.8, IF A1<200*.6, IF A1 <300*.5.
And where is the less than/ equal sign at?
And where is the less than/ equal sign at?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
Hi,
If statements take the form of
=if(a1=somthing,do this if true,do this if false)
If you tell us what the true and false conditions evaluate as then someone
will help
Less then equal to is done using >=
Mike
If statements take the form of
=if(a1=somthing,do this if true,do this if false)
If you tell us what the true and false conditions evaluate as then someone
will help
Less then equal to is done using >=
Mike
M
Mike H
or
<=
for less then = to
<=
for less then = to
K
knight
Thanks for responding so quickly, Mike. This is for a sales report where in
the column I input a material # in say, A1. I then want column A2 to
calculate that if the # in A1 is < $100 then multiply by .8, if A1 is < $200
multiple by .6. This way it computes my mark up.
the column I input a material # in say, A1. I then want column A2 to
calculate that if the # in A1 is < $100 then multiply by .8, if A1 is < $200
multiple by .6. This way it computes my mark up.
M
Mike H
Perhaps
=IF(A1<=100,A1*1.06,IF(A1<=200,A1*1.08,A1*1.05))
Mike
=IF(A1<=100,A1*1.06,IF(A1<=200,A1*1.08,A1*1.05))
Mike
K
knight
Thanks a million. It works Great.
Mike H said:Perhaps
=IF(A1<=100,A1*1.06,IF(A1<=200,A1*1.08,A1*1.05))
Mike