Formula

[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?

 

[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

 

[Mike H]

or

<=

for less then = to

 

[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.

 

[Mike H]

Perhaps

=IF(A1<=100,A1*1.06,IF(A1<=200,A1*1.08,A1*1.05))

Mike

 

[knight]

Thanks a million. It works Great.

Perhaps

=IF(A1<=100,A1*1.06,IF(A1<=200,A1*1.08,A1*1.05))

Mike