Help me in using IF formula with condition

Closed
arun - Jun 26, 2010 at 02:38 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 26, 2010 at 07:44 AM
Hello,

plese help in my problem

in excell i have a column for revenues (say $50 M to $150 M)
my question is if the company revenue =50 and Revenue <70 it should print "SMALL" in next cell and if revenue >=70 and Revenue <100 it should print "MEDIUM" and revenue=100 and revenue <=150 should print "BIG".

what could be the formula for this?

please let me know on my email id basaarun@yahoo.com

Thanks,
Arun
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 26, 2010 at 07:44 AM
Lets say Revenue is in cell A1 and you want the word to appear in b1

then in b1 add

=IF(OR(A1>150, A1<50, A1=""), "", IF(A1>=100,"BIG", IF(A1>=70, "MEDIUM","SMALL")))