IF AND & #VALUE! error

Hello Forum

I have the below code which works great but for one of the criterias i will always get a error as that is how the data is generated, i tried a few thing but i couldnt get the code to work.

I have entered the error code in the formula where it would be on the spreadsheet

Thank you in advance

Formula:

Please Login or Register  to view this content.

Try

=IFERROR(IF(S3=3,IF(U3=2,"yes",""),""),"no")

So only "No" if ERROR condition

Hello Shukla

Your code returned a error

Hello John

It has to stay in the same format as i have just done a simple version of teh code i am using, there is mre levels to the nested IF AND

Thanks