Hi,
Question: I have a formula that works, but I want to wrap it and add a FALSE CONDITION in case I get a FALSE.
Here is the working formula, but it gives me a FALSE.
How can I add the following condition to the above: If the above formula output is FALSE, then I want it to default to the value in Dashboard!$H$10.
Any ideas?
Thanks!
Question: I have a formula that works, but I want to wrap it and add a FALSE CONDITION in case I get a FALSE.
Here is the working formula, but it gives me a FALSE.
Code:
=IF(IFERROR(IF(OR(F154="Y",AN154<=6),AQ154,IF(AND(O154="Y",SEARCH("Comp",D154),LEFT(D154,2)+0>24,AQ154>=Dashboard!$I$10),AQ154,IF(AND(O154="Y",SEARCH("Comp",D154),LEFT(D154,2)+0>24,VLOOKUP(A154,'WOs (DSP Only)'!A:B,2,FALSE)>=Dashboard!$I$10,VLOOKUP(A154,'WOs (DSP Only)'!A:C,3,FALSE)>=Dashboard!$I$10,VLOOKUP(A154,'WOs (DSP Only)'!A:D,4,FALSE)>=Dashboard!$I$10,VLOOKUP(A154,'WOs (DSP Only)'!A:E,5,FALSE)>=Dashboard!$I$10,VLOOKUP(A154,'WOs (DSP Only)'!A:F,6,FALSE)>=Dashboard!$I$10,(ROUNDDOWN(365/((AN154*AQ154)/VLOOKUP(CONCAT(D154,"-",O154),Calibration!P:T,5,FALSE)),0))>ROUNDDOWN(AR154,0)),Dashboard!$I$10,IF(AND(O154="Y",SEARCH("Comp",D154),LEFT(D154,2)+0>24,VLOOKUP(A154,'WOs (DSP Only)'!A:B,2,FALSE)<Dashboard!$H$10,VLOOKUP(A154,'WOs (DSP Only)'!A:C,3,FALSE)<Dashboard!$H$10,VLOOKUP(A154,'WOs (DSP Only)'!A:D,4,FALSE)<Dashboard!$H$10,VLOOKUP(A154,'WOs (DSP Only)'!A:E,5,FALSE)<Dashboard!$H$10,VLOOKUP(A154,'WOs (DSP Only)'!A:F,6,FALSE)<Dashboard!$H$10,(ROUNDDOWN(365/((AN154*AQ154)/VLOOKUP(CONCAT(D154,"-",O154),Calibration!P:S,4,FALSE)),0))>ROUNDDOWN(AR154,0)),Dashboard!$H$10,IF(AND(VLOOKUP(A154,'WOs (DSP Only)'!A:B,2,FALSE)>=Dashboard!$H$10,VLOOKUP(A154,'WOs (DSP Only)'!A:B,2,FALSE)<Dashboard!$I$10,ROUNDDOWN(365/((AN154*AQ154)/VLOOKUP(A154,'WOs (DSP Only)'!A:B,2,FALSE)),0)>ROUNDDOWN(AR154,0)),VLOOKUP(A154,'WOs (DSP Only)'!A:B,2,FALSE),IF(AND(VLOOKUP(A154,'WOs (DSP Only)'!A:C,3,FALSE)>=Dashboard!$H$10,VLOOKUP(A154,'WOs (DSP Only)'!A:C,3,FALSE)<Dashboard!$I$10,ROUNDDOWN(365/((AN154*AQ154)/VLOOKUP(A154,'WOs (DSP Only)'!A:C,3,FALSE)),0)>ROUNDDOWN(AR154,0)),VLOOKUP(A154,'WOs (DSP Only)'!A:C,3,FALSE),IF(AND(VLOOKUP(A154,'WOs (DSP Only)'!A:D,4,FALSE)>=Dashboard!$H$10,VLOOKUP(A154,'WOs (DSP Only)'!A:D,4,FALSE)<Dashboard!$I$10,ROUNDDOWN(365/((AN154*AQ154)/VLOOKUP(A154,'WOs (DSP Only)'!A:D,4,FALSE)),0)>ROUNDDOWN(AR154,0)),VLOOKUP(A154,'WOs (DSP Only)'!A:D,4,FALSE),IF(AND(VLOOKUP(A154,'WOs (DSP Only)'!A:E,5,FALSE)>=Dashboard!$H$10,VLOOKUP(A154,'WOs (DSP Only)'!A:E,5,FALSE)<Dashboard!$I$10,ROUNDDOWN(365/((AN154*AQ154)/VLOOKUP(A154,'WOs (DSP Only)'!A:E,5,FALSE)),0)>ROUNDDOWN(AR154,0)),VLOOKUP(A154,'WOs (DSP Only)'!A:E,5,FALSE),IF(AND(VLOOKUP(A154,'WOs (DSP Only)'!A:F,6,FALSE)>=Dashboard!$H$10,VLOOKUP(A154,'WOs (DSP Only)'!A:F,6,FALSE)<Dashboard!$I$10,ROUNDDOWN(365/((AN154*AQ154)/VLOOKUP(A154,'WOs (DSP Only)'!A:F,6,FALSE)),0)>ROUNDDOWN(AR154,0)),VLOOKUP(A154,'WOs (DSP Only)'!A:F,6,FALSE)))))))))),"Not Needed")=FALSE,Dashboard!$I$10,IFERROR(IF(OR(F154="Y",AN154<=6),AQ154,IF(AND(O154="Y",SEARCH("Comp",D154),LEFT(D154,2)+0>24,AQ154>=Dashboard!$I$10),AQ154,IF(AND(O154="Y",SEARCH("Comp",D154),LEFT(D154,2)+0>24,VLOOKUP(A154,'WOs (DSP Only)'!A:B,2,FALSE)>=Dashboard!$I$10,VLOOKUP(A154,'WOs (DSP Only)'!A:C,3,FALSE)>=Dashboard!$I$10,VLOOKUP(A154,'WOs (DSP Only)'!A:D,4,FALSE)>=Dashboard!$I$10,VLOOKUP(A154,'WOs (DSP Only)'!A:E,5,FALSE)>=Dashboard!$I$10,VLOOKUP(A154,'WOs (DSP Only)'!A:F,6,FALSE)>=Dashboard!$I$10,(ROUNDDOWN(365/((AN154*AQ154)/VLOOKUP(CONCAT(D154,"-",O154),Calibration!P:T,5,FALSE)),0))>ROUNDDOWN(AR154,0)),Dashboard!$I$10,IF(AND(O154="Y",SEARCH("Comp",D154),LEFT(D154,2)+0>24,VLOOKUP(A154,'WOs (DSP Only)'!A:B,2,FALSE)<Dashboard!$H$10,VLOOKUP(A154,'WOs (DSP Only)'!A:C,3,FALSE)<Dashboard!$H$10,VLOOKUP(A154,'WOs (DSP Only)'!A:D,4,FALSE)<Dashboard!$H$10,VLOOKUP(A154,'WOs (DSP Only)'!A:E,5,FALSE)<Dashboard!$H$10,VLOOKUP(A154,'WOs (DSP Only)'!A:F,6,FALSE)<3,(ROUNDDOWN(365/((AN154*AQ154)/VLOOKUP(CONCAT(D154,"-",O154),Calibration!P:S,4,FALSE)),0))>ROUNDDOWN(AR154,0)),Dashboard!$H$10,IF(AND(VLOOKUP(A154,'WOs (DSP Only)'!A:B,2,FALSE)>=Dashboard!$H$10,VLOOKUP(A154,'WOs (DSP Only)'!A:B,2,FALSE)<Dashboard!$I$10,ROUNDDOWN(365/((AN154*AQ154)/VLOOKUP(A154,'WOs (DSP Only)'!A:B,2,FALSE)),0)>ROUNDDOWN(AR154,0)),VLOOKUP(A154,'WOs (DSP Only)'!A:B,2,FALSE),IF(AND(VLOOKUP(A154,'WOs (DSP Only)'!A:C,3,FALSE)>=Dashboard!$H$10,VLOOKUP(A154,'WOs (DSP Only)'!A:C,3,FALSE)<Dashboard!$I$10,ROUNDDOWN(365/((AN154*AQ154)/VLOOKUP(A154,'WOs (DSP Only)'!A:C,3,FALSE)),0)>ROUNDDOWN(AR154,0)),VLOOKUP(A154,'WOs (DSP Only)'!A:C,3,FALSE),IF(AND(VLOOKUP(A154,'WOs (DSP Only)'!A:D,4,FALSE)>=Dashboard!$H$10,VLOOKUP(A154,'WOs (DSP Only)'!A:D,4,FALSE)<Dashboard!$I$10,ROUNDDOWN(365/((AN154*AQ154)/VLOOKUP(A154,'WOs (DSP Only)'!A:D,4,FALSE)),0)>ROUNDDOWN(AR154,0)),VLOOKUP(A154,'WOs (DSP Only)'!A:D,4,FALSE),IF(AND(VLOOKUP(A154,'WOs (DSP Only)'!A:E,5,FALSE)>=Dashboard!$H$10,VLOOKUP(A154,'WOs (DSP Only)'!A:E,5,FALSE)<Dashboard!$I$10,ROUNDDOWN(365/((AN154*AQ154)/VLOOKUP(A154,'WOs (DSP Only)'!A:E,5,FALSE)),0)>ROUNDDOWN(AR154,0)),VLOOKUP(A154,'WOs (DSP Only)'!A:E,5,FALSE),IF(AND(VLOOKUP(A154,'WOs (DSP Only)'!A:F,6,FALSE)>=Dashboard!$H$10,VLOOKUP(A154,'WOs (DSP Only)'!A:F,6,FALSE)<Dashboard!$I$10,ROUNDDOWN(365/((AN154*AQ154)/VLOOKUP(A154,'WOs (DSP Only)'!A:F,6,FALSE)),0)>ROUNDDOWN(AR154,0)),VLOOKUP(A154,'WOs (DSP Only)'!A:F,6,FALSE)))))))))),"Not Needed"))
How can I add the following condition to the above: If the above formula output is FALSE, then I want it to default to the value in Dashboard!$H$10.
Any ideas?
Thanks!