WirelessJoe
New Member
- Joined
- Jan 7, 2021
- Messages
- 5
- Office Version
- 2016
- Platform
- Windows
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.
=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.