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

something like this
=if(A15(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