Set cell value based upon another cell

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

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
 
Hi Gary
a non VBA solution: enter the following in B1:
=IF(A1=1,"Y","")
and copy down
 
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")]
 
Put this in cell B1:

=IF(A1=1,"Y","")

This only works if you want column B's cells to be blank if the valu
in column A is "1". Otherwise you'll have to ammend the formula lik
this:

=IF(A1=1,"Y","N")

- Piku
 
Back
Top