Satisfying Multiple Criteria in an "IF" Function

  • Thread starter Thread starter Jerry B Smith
  • Start date Start date
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
 
Back
Top