Help to fix formula ="Yes"

P

Pat

The following formula is not doing what it is supposed to be doing:

=IF(AND(I87-J87>0,S87="Yes"),0,I87-J87)

A value should only be returned if S87="Yes"

What happens is a value is returned regardless if S87="Yes" or not. Anyone
know what is wrong here?

Thanks
Pat
 
P

peter

Hi,
the "yes" in the formula needs to be double quoted...
the yes in cell s87 does not.

peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF/AND Formula Problem 9
Desplay zero if yes 4
Problem with =IF(AND........ formula 5
If yes then display information in cell 2
Formula Returning "FALSE" 2
Modify a Formula 1
Add condition to formula 3
Help needed for Excel formula using if, iserr, match and vlookup! 1

Top