Format Error using "IF" with "AND"

[Mike Slattery]

Hi:

Excel Mac 2011 wants to correct the following formula by adding a times symbol (*) between two elements of the formula?

Can someone tell me the correct format for the following formula?

=IF(AND(CO3>0,CK3<3,)CA3,"",)

I want the value in CA3 if both conditions are true and nothing if neither or only one condition is true.

Thanks for you help,

Michael

 

[pgc01]

Hi Michael

Try:

=IF(AND(CO3>0,CK3<3),CA3,"")

I want the value in CA3 if both conditions are true and nothing if neither or only one condition is true.

Remark: it's not possible to have the cell with nothing (empty) as a result of a formula. In this case the formula returns a null string if the conditions are not met.

 

[Snakehips]

Mike, looks like misplaced commas, try….


=IF(AND(CO3>0,CK3<3),CA3,"")

 

[Mike Slattery]

Hi Snakehips:

Thanks, that was the problem. Very grateful, Michael