# Help with an IF (?) formula

#### djb_36

##### New Member
Hello,

Here's what I am trying to do. I have 5 numbers which are milestones. Those milestones are 4.80, 4.08, 3.90, 1.67, and 0.00. For my spreadsheet I have listed them in B14 through B18 respectively.

I have done a calculation at another point on the page that returns a number. The calculation is based on a series of variables and is working fine. In the first example, my calculation is returning a 3.99.

What I would like to happen is...

If that returned calculation is greater than or equal to 4.80, I return a value (either something I set or reference elsewhere).

If the returned calculation is less than 4.80 but greater than or equal to 4.08, then return a different value.

If the returned calculation is less than 4.08 but greater than or equal to 3.90, then return a different value.

If the returned calculation is less than 3.90 but greater than or equal to 1.67, then return a different value.

If the returned calculation is less than 1.67 then return a different value.

Help!!

Thank you in advance. Best regards - DJB

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

##### Active Member
Try this:

=if(A1<1.67, V, if(A1<3.90, W, if(A1<4.08,X, if(A1<4.80,Y,Z))))

#### Scott Huish

##### MrExcel MVP
Hi, welcome to the board!

Have a look at the VLOOKUP function.

If you can provide more specific details, and possibly a sample of your sheet (Link to Colo's HTML maker is at the bottom of this page) with expected results, someone could possibly help you out with more specifics.

##### MrExcel MVP
Something like...

=LOOKUP(A2,\$B\$14:\$B\$18,\$C\$14:\$C\$18)

where A2 houses a calculated value that serves as lookup value, B14:B18 houses the values you discuss, and C14:C18 values that you would want to return, but you did not mention what they are.

Replies
9
Views
1K
Replies
15
Views
422
Replies
4
Views
283
Replies
7
Views
2K
Replies
9
Views
558

1,182,025
Messages
5,933,333
Members
436,888
Latest member
Kantonides

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