cell value depends on value in another cell question

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.
 
C

CLR

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
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top