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