Newbie..question on conditional formula

[mspm47]

Trying to finish a fast project and hit a mental block on something many of you will probably find simple.
i am doing a list of insurance costs that is driven by a table

0 to 700 is $45
701 to 900 is $75
901 to 1200 is $90
etc etc
these rates are based on one number per customer.
what formula or string of formulas do i use to take this customer number and insert the dollar amount based on the range in the table above?

Somehow this is escaping me. Anyone got solution?
thanks
Peace, Love and Parking Spots

 

[Aladin Akyurek]

Trying to finish a fast project and hit a mental block on something many of you will probably find simple.
i am doing a list of insurance costs that is driven by a table

0 to 700 is $45
701 to 900 is $75
901 to 1200 is $90
etc etc
these rates are based on one number per customer.
what formula or string of formulas do i use to take this customer number and insert the dollar amount based on the range in the table above?

Somehow this is escaping me. Anyone got solution?
thanks
Peace, Love and Parking Spots

=LOOKUP(A2,{0,701,901},{45,75,90})

 

[mspm47]

LOOKUP!!!! THATS IT!
I kept trying to force a CONDITIONAL formula.

My fear of being a total moron has been averted, at least for awhile!!!!!

Good karma for you