Assuming you want blanks to be returned as the value_if_false:

Put in B1: =IF(A1=1,"Y","")
Copy B1 down

[Alternatively, put in B1: =IF(A1<1,"","Y")]

--
Rgds
Max
xl 97
---
Please respond, in newsgroup
xdemechanik <atyahoo<dotcom
----
"Gary" wrote in message
...
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