If Then
 

I am trying to program a cell to look at the total in another cell which has
unlimited possibilities. From the total I want to have it look at a total
and if it is <= or = to a number then it assigns a value. e.g. If the
total is 225 in one cell then this is greater than 200 and less than 250 so
it equals $125. Thanks for your help!

If Then
 

=IF(AND(A1<=250,A1=200),125,"")

--

Vasant

"impressions" wrote in message
...
I am trying to program a cell to look at the total in another cell which
has
unlimited possibilities. From the total I want to have it look at a total
and if it is <= or = to a number then it assigns a value. e.g. If the
total is 225 in one cell then this is greater than 200 and less than 250
so
it equals $125. Thanks for your help!

If Then
 

You can use a Select Case construct like so

Select Case Range("A1").Value
Case Is <10
'Do This
Case is <=20
'Do That
Case is <=30
'Do Something Else
Case Else
'Do Something Totally Different
End Select
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"impressions" wrote in message
...
I am trying to program a cell to look at the total in another cell which
has
unlimited possibilities. From the total I want to have it look at a total
and if it is <= or = to a number then it assigns a value. e.g. If the
total is 225 in one cell then this is greater than 200 and less than 250
so
it equals $125. Thanks for your help!