I want to place a "x" in a cell and give it a value of 1 (Excel)

jpe · May 16, 2006

I want to place a "x" in a cell and give it a value of 1

davesexcel · May 16, 2006

=if(a1="x",1,"")

something like this?