If Function help

[mansfieldtw]

I have what should be a simple IF then formula, which is copied below,
where both criteria must be met: Z9 must be true and S9 must = COS.
Any assistance why this isn't working would be greatly appreciated.

=IF(AND(Z9=TRUE,S9="COS"),B9,"N/A")

Thanks!

 

[Roger Govier]

Hi
What is contained in Z9?
Maybe you need
=IF(AND(Z9,S9="COS"),B9,"N/A")

 

[Erny]

Try:

=IF((Z9=TRUE)*(S9="COS")=1,B9,"N/A")

Kind regards,
Erny

 

[Ron Rosenfeld]

I have what should be a simple IF then formula, which is copied below,
where both criteria must be met: Z9 must be true and S9 must = COS.
Any assistance why this isn't working would be greatly appreciated.

=IF(AND(Z9=TRUE,S9="COS"),B9,"N/A")

Thanks!

Your formula works as I would expect it to work.

So I guess the problem is either in your data, your understanding of that data,
or in your concept of what "isn't working" really means.

Since you chose to post none of that, it would be difficult to give you more
assistance.
--ron

 

[mansfieldtw]

Hi
What is contained in Z9?
Maybe you need
=IF(AND(Z9,S9="COS"),B9,"N/A")

Z9 simply had a true/false formula. Erny's suggested formula worked.
Thank you both!!!!