Conditional Formula Needed

[fishin]

Need a formula for the following.

The recipient cell is to equal the value posted in cell F82 if the value in cell F83 = "NON-COMPLIANT" and if the value posted in cell M83 = "X"


Help is greatly appreciated.

 

[JackDanIce]

Try:

=IF(F83&M83="NON-COMPLIANTX",F82,"")

 

[fishin]

Try:

=IF(F83&M83="NON-COMPLIANTX",F82,"")

Thanks Jack....much appreciated. Worked great.

 

[JackDanIce]

You're welcome