# Newbie..question on conditional formula

#### mspm47

##### New Member
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

### Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

##### MrExcel MVP
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

##### New Member
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

Replies
3
Views
552
Replies
1
Views
369
Replies
2
Views
6K
Replies
5
Views
349
Replies
0
Views
184

1,191,031
Messages
5,984,235
Members
439,879
Latest member
KingGoulash

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back