Help with an IF (?) formula

[djb_36]

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

 

[Padawan]

Try this:

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

Where A1 = your cell reference, V-Z = your returned value.

 

[Scott Huish]

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.

 

[Aladin Akyurek]

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.