I have a scenario where I need to check the below condition and publish the result in the output column of the excel, but after fulfilling the condition too , i am unable to do the same.
My condition is ,
If age < 30 and address is not able or age > 30 and phone no is not available then output column should be fill as Fail.
Else if all the three data are available say suppose age = 30, address is also available & Phone No is also available, the output should be Pass.
I am using the condition as ,
checkAge<30 and checkAddress=Nothing or checkAge>30 and checkPhone=Nothing