Hi All

I want to set the value of a cell based upon the value in
another cell.

ie if cell a1 = '1' then cell b1 = 'Y'
if cell a2 = '21' then leave cell b2 as a2 is not 1

Any assistance would be appreciated.

Thanks