Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|