Hi,

I would like to make a cell conditional upon the content of another cell.

E.g.

if A1 is >30 then A2 should be 'Must'
if A1 is >20 but less than 30 then A2 should be 'Should'

Thank you in advance!