how can i remove #value! from this formula?

[nellyc]

=IF(AND($D$9>1)*$C$22=1,"Yes","No")

Thanks

Nelly

[Craig K.]

Nelly - Some context would be good. Maybe post the spreadsheet with sensitive data removed.

[BenMiller]

=IF(($D$9>1)*($C$22=1),"Yes","No")

or

=IF(AND($D$9>1,$C$22=1),"Yes","No")

[Jonmo1]

Try actually using the AND

=IF(AND($D$9>1,$C$22=1),"Yes","No")

[Tony Valko]

If C22 contains a text entry then you'll get the #VALUE! error.

Maybe you meant this:

=IF(AND($D$9>1,$C$22=1),"Yes","No")

[nellyc]

Thank You Mr Ben Miller - as you state - Prefect

[BenMiller]

No problem ... glad I could help. Appreciate the feedback!