Replicating IF

Topic

New Reply

This seems simple enough, but I can’t seem to figure it out. I need to replicate the following formula found in cell A2 through the remaining cells in column A:

=IF($L$2=”No”,”Closed”,”Open”)

It works fine for A2, but I can’t copy it to the remaining cells in column A; it keeps looking at the value of L2 rather than its respective “L” value (ie, L3, L4, etc).

Reply | Quote

Replies

=IF($L2=”No”,”Closed”,”Open”)

or if you want to copy to other columns as well:

=IF(L2=”No”,”Closed”,”Open”)

The dollar signs ($) lock it on the column or row…

Steve

Reply | Quote

=IF($L2=”No”,”Closed”,”Open”)

or if you want to copy to other columns as well:

=IF(L2=”No”,”Closed”,”Open”)

The dollar signs ($) lock it on the column or row…

Steve

Thanks Steve, I discovered the error right about the time you replied. Thanks for the help!!

Reply | Quote

Ooops, guess I had dollar signs floating around in my head from other formulas. I removed them from this one and all is well – sheeesh!

Reply | Quote