If Function help

M

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!
 
R

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!
Click to expand...

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
 
M

mansfieldtw

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


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