OK, I am not sure how to even begin to search for this because I am unsure of
the nomenclature I need to look for. That said, here is what I am looking to
understand:

I need to display a value of "1" if a total (manually entered in an adjacent
cell) is 20-29; "2" if a total is 30-39; and "3" if a total is 40+. So if the
entered value is 25, the value displayed in the adjacent cell would be "1".

Can and how do I do this?
Many thanks in advance!