cell value depends on value in another cell question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. Anyone know how to have a cell formula control the information in another cell? I'm trying to get a row of cells to only allow one x (trying to get them to act like a check box that only allows one check). I can't figure if excel is capable of controling a cell's value from an outside formula.
 
Maybe.......... =IF(A1=1,"X","")

Vaya con Dios,
Chuck, CABGx3



Sylvia said:
Hi. Anyone know how to have a cell formula control the information in
Click to expand...
another cell? I'm trying to get a row of cells to only allow one x (trying
to get them to act like a check box that only allows one check). I can't
figure if excel is capable of controling a cell's value from an outside
formula.
 
Back
Top