Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|