"AND" in a formula?

[AdamW328]

Hi,

can someone please assist me so I get the syntax right for this formula. I know the "AND" is in the wrong spot and there are other issues as well. I want the cell with the formula to read "Buy" if L12>L16*1.025 AND L12<.90*L14

This is the way I currently have it:

=IF(L12>L16*1.025 And L12<.90*L14 "Buy", "")

Thanks

[JohnTopley]

Try

=IF(AND(L12>L16*1.025, L12<.90*L14), "Buy", "")

[AdamW328]

That worked great! Thanks

[zbor]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules.

http://www.excelforum.com/excel-form...-forumula.html