# Multi-result IF Statements...

#### jacobswenson

##### New Member
I am running a contest at work and I need a cell to return different values IF based on the returns results. For example the column header is "Current Reward" and I want it to return either "\$500", "\$750" or "\$1,000" depending on the the data at specific value benchmanrks.

I know I am doing this wrong but this is what I have been trying: =IF(AND(K3>.25, K3<.3499, "\$500":wink:)... and then I get stuck.

The results should return these truths: K3>.25 or <.3499 = "\$500", BUT IF K3>.35 and <.4499 = "\$750", BUT IF K3>.45 and <.7499 = "\$1,000". Does that make any sense? Not sure where to turn for this one - couldn't find this type of problem on any of the threads... Please help!!

Jake

### Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

#### FormR

##### MrExcel MVP
Hi, here is one possible option you can try that doesn't involve nesting IF() functions.

=LOOKUP(K3,{0,0.25,0.35,0.45,0.75},{0,500,750,1000,"Over.."})

#### chicagocomputerclasses

##### Well-known Member
Code:
``=VLOOKUP(K3,{0,"None";0.25,500;0.35,750;0.45,1000;0.75,"None"},2,1)``

Last edited:

Replies
2
Views
1K
Replies
8
Views
356
Replies
10
Views
546
Replies
1
Views
86
Replies
1
Views
309

1,195,671
Messages
6,011,077
Members
441,581
Latest member
rp4717

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