Forum Discussion
The AND function
In cell I5, enter a formula using the AND function that tests whether the Wireless value is equal to "Y" and whether the discount value is equal to "Y".
Every time I enter a formula, it comes back INVALID. I'm not sure what I'm doing wrong
2 Replies
In addition please check shall you use in your locale commas or semicolons as separators in formulas.
=IF(AND(wireless="Y",discount="Y"),"Passes Test","Fails Test")
In place of wireless enter the cell address of whatever cell you're putting in the values of "Y" or (presumably) "N"
Same for discount--enter the appropriate cell address.
For future reference though, or if you're not able to make the formula work that I've given you it would help if you were to post a copy of the spreadsheet you're working with or, at the very least, examples of the formulas that aren't working for you.
