Formula
 

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?

Formula
 

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

"knight" wrote:

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?

Formula
 

or

<=

for less then = to

"knight" wrote:

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?

Formula
 

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" wrote:

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

"knight" wrote:

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?

Formula
 

Perhaps

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

Mike

"knight" wrote:

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" wrote:

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

"knight" wrote:

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?

Formula
 

Thanks a million. It works Great.

"Mike H" wrote:

Perhaps

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

Mike

"knight" wrote:

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" wrote:

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

"knight" wrote:

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?