How do I write an excel formula with a text answer ("yes" or "no")

P

pat

I wish to compare a value (number) in a cell with 2 other numbers and arrive
at either a "yes" or "no" answer. Example: If C19 is equal to or more than
C18 , and equal to or less than C17, then the resulting answer is "yes"; If
C19 is less than C18 or more than C17, then the resulting anwer is "no".
 

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

Either or Formula 4
Subtracting minutes in an +IF formula 13
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
I'm a Newbie, Need Formula 5
Holding the result of a formula constant or frozen 1
How do I Make a "IF" formula where it reads between 2 sets of numb 2
Excel Need Countifs Formula Help 0
How to create a formula with multiple (IF) conditions 3

Top