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 how this works: =IF(A1<300,"Private",IF(A1<2000,"Small-Cap",IF(A1<10000,"Mid-Cap","Large-Cap")))

MIKE

Ask Your Question

Weekly Poll