Thread: 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(AND(A1<=250,A1>=200),125,"")

--

Vasant

"impressions" <impressions@discussions.microsoft.com> wrote in message
news:564C0F22-2048-4F7B-8C31-B31FFCB75E64@microsoft.com...
> 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!

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
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

"impressions" <impressions@discussions.microsoft.com> wrote in message
news:564C0F22-2048-4F7B-8C31-B31FFCB75E64@microsoft.com...
>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!