Nested If's

[sur]

I have 2 if formulas, need to combine in to One


=IF(AND(ISNUMBER(H2)=TRUE,LEN(H2) =10,OR(LEFT(H2,1) ="10",LEFT(H2,1) = "9")),"","Invalid")


=IF(OR(R2="0",R2="",R2="#N/A"),"Not Found","")


orelse it should be "Correct"


Please help on this

 

[bbott]

Which statement takes precedence (i.e. do you want to validate R2 or H2 first)?

 

[sur]

I am not clear on this
It should be H2,

 

[bbott]

Try:

=IF(AND(ISNUMBER(H2),LEN(H2) =10,OR(LEFT(H2,2) ="10",LEFT(H2,1) = "9")),IF(OR(R2={0,"","#N/A"}),"Not Found","Correct"),"Invalid")