Satisfying Multiple Criteria in an "IF" Function

J

Jerry B Smith

I need a formula that looks to see that a value is greater than one cell and
less than or equal to another. If the results are valid, I want it to say
"yes". If not valid, then result as blank. I have an IF formula that satifies
one value but not for two. It looks like this:

if(A1=B1,C1,"")

How do I make it work to satisfy multiple criteria? Thanks
 

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

Top