Thread
:
If Then
View Single Post
#
3
Posted to microsoft.public.excel.programming
Nick Hodge
external usenet poster
Posts: 1,173
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!
Reply With Quote
Nick Hodge
View Public Profile
Find all posts by Nick Hodge