Help with an IF (?) formula

djb_36

New Member
Joined
Jan 26, 2005
Messages
6
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

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Padawan

Active Member
Joined
Apr 9, 2002
Messages
392
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

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
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.
 

Forum statistics

Threads
1,148,216
Messages
5,745,431
Members
423,951
Latest member
peggrif

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top