Receiving "False" result from nested formula with multiple conditions

[WirelessJoe]

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.

 

[JamesCanale]

Really hard to follow:

=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:

=if(4=3,"")

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

 

[WirelessJoe]

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.

 

[JamesCanale]

You're welcome.

I love a puzzle.