Extended Formula (maybe If,then with multiple ANDs/ORs)

[jtothej]

I need a formula that can support this statement...

<$1M 30 points
$1M - $2M 60 points
$2M - $4M 90 points
$4M - $7M 120 points
$7M+ 150 points

Can anyone help?

 

[Joe4]

Here are a few different ways.

If the amount you are checking is in cell A1, then this nested IF statement would work:
IF(A1>=7000000,150,IF(A1>=4000000,120,IF(A1>=2000000,90,IF(A1>=1000000,60,30))))

Or you can use LOOKUP, like this:
=LOOKUP(A1,{0,1000000,2000000,4000000,7000000},{30,60,90,120,150})

 

[DanteAmor]

If you want to compare a smaller number of zeros:

=LOOKUP(A1/1000000,{0,1,2,4,7},{30,60,90,120,150})