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

Help me in using IF formula with condition
Date formula in excel dd/mm/yyyy - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers
Number to words in excel formula - Guide
Excel grade formula - Guide
Cardtext formula in word - Guide

1 response

Answer 1 / 1

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")))

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

How to use conditional format based on text?

Similar discussions

Subscribe To Our Newsletter!