Solved Excel 2010 IF function query

November 15, 2016 at 07:41:42
Specs: Windows 7
I need to be able to create a formula for the following criteria:

Large-cap : >= $10000
Mid-cap : >= $2000 but < $10000
Small-cap : >= $300 but < $2000
Micro/Nano : < $300
Private : 0


See More: Excel 2010 IF function query

Report •

#1
November 15, 2016 at 12:08:44
✔ Best Answer
See how this works:

=IF(A1<300,"Private",IF(A1<2000,"Small-Cap",IF(A1<10000,"Mid-Cap","Large-Cap")))

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question