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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - I want to place a "x" in a cell and give it a value of 1 (Excel) (https://www.excelbanter.com/excel-worksheet-functions/88973-i-want-place-x-cell-give-value-1-excel.html)

jpe

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

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

davesexcel

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

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

something like this??

--
davesexcel

------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=542714

All times are GMT +1. The time now is 12:06 PM.