conditional formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was hoping someone could show me how to compare two cells to populate a
third.

something like this
=if(A1>5(and(A2<20)), "moderate", "")

reading if A1 is greater than 5 and A2 is less than 20, return the string
moderate, else leave the cell blank.

Thanks
 
Back
Top