Thread: IF STATEMENT
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gaurav[_2_] Gaurav[_2_] is offline
external usenet poster
 
Posts: 207
Default IF STATEMENT

What if A1 is between 3% and 3.9%?

"TRYIN" wrote in message
...
I NEED HELP WITH THE FOLLOWING IF STATEMENT:
IF A1 IS BETWEEN 1% AND 1.9% =50
IF A1 IS BETWEEN 2% AND 2.9% =100
IF A1 IS 4% OR MORE =150