Need help in formula.. OR combination

[VBABEGINER]

Current Formula is -

=IF(OR(ISBLANK($AJ2)=TRUE,$AJ2="Issued from History"),"Complete",
IF(AO2="Process Support","Closed","Closed"))

here problem is, when im selecting "process support" in col AO all my answers are not shown as "Closed" because, as per the 1st OR condition if col AJ finds "blank" or "Issued from history" my answer shown as "Complete".

Can anyone help me in set this logic..

 

[tyija1995]

Hey,

So if AO2 is "Process Support" you want to output "Closed", otherwise if either AJ2 is blank or "Issued from History" you want to see "Complete"? If so try this:

=IF(AO2="Process Support","Closed",IF(OR(ISBLANK($AJ2),$AJ2="Issued from History"),"Complete","Placeholder"))

I put in a placeholder as I am unsure what value you want to see if the OR condition is FALSE and AO2 is not equal to "Process Support".

 

[VBABEGINER]

you are giving my formula only.. in different manner