Forum Discussion
How To? If # in column then populate in other cell
Hello, I am looking for some help automating an entry process. I have attached a photo of what I would like to have accomplished. In my spreadsheet I have several rows of numbers in Column A....
I've created a Formula =IF(A2=1),"1","0")
This is not 100% automated and you can't replicate it, it's necessary to build the entire table manually.
=IF(Logical Formula,"Value if True","Value if False")
- Thanks, this has helped me speed things up.
