# Receiving "False" result from nested formula with multiple conditions

#### WirelessJoe

##### New Member
Hello, I'm using the following formula to select a pay curve based on two conditions: a job title (selected through data validation dropdown in cell C6) and whether or not their YTD and QTD revenue is over 100% (cells C52 and C46) If the title is "Job1" it should select from the pay curve in column B, if the title is "Job2" it should select from column C.

=IFERROR(IF(\$C\$6="Job1",IF(AND(C52<100%,C46>100%),C46,INDEX('Pay Curves'!\$B:\$B,MATCH(C46,'Pay Curves'!\$A:\$A,0))),IF(\$C\$6="Job2",IF(AND(C52<100%,C46>100%),C46,INDEX('Pay Curves'!\$C:\$C,MATCH(C46,'Pay Curves'!\$A:\$A,0))))),"")

For the two job titles in the formula, this works fine. However, I have a several other titles (None, Job3, etc.) that, when selected in cell C6, gives me a "False" result. I was trying, with the IFERROR, to simply have it return nothing "". How can I return a blank or zero?

Thanks in advance for any insight you might be able to provide.

### Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

#### JamesCanale

##### Board Regular
Really hard to follow:

Excel Formula:
``=IF(\$C\$6="Job1",IF(AND(C52<100%,C46>100%),C46,INDEX('Pay Curves'!\$B:\$B,MATCH(C46,'Pay Curves'!\$A:\$A,0))),IF(\$C\$6="Job2",IF(AND(C52<100%,C46>100%),C46,INDEX('Pay Curves'!\$C:\$C,MATCH(C46,'Pay Curves'!\$A:\$A,0))),""))``

You missed that ,"" near the end on a dangling false condition.

Basically, if you write:

Excel Formula:
``=if(4=3,"")``

it will return FALSE because you didn't put that last parameter in.

#### WirelessJoe

##### New Member
Thank you for fixing this, it does work now. I'm relatively new to more complex formulas, and appreciate the time you took to help.

You're welcome.

I love a puzzle.

Replies
3
Views
79
Replies
3
Views
85
Replies
1
Views
114
Replies
10
Views
394
Replies
1
Views
115

1,129,478
Messages
5,636,567
Members
416,924
Latest member
cmlacerna

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