J
Jim
I'm using excel 2007.
I'm looking to have a logical test in one cell that will populate a
different cell if true, or a third cell if false.
For example, the logical test located in cell A1: If (A2=3, then Cell B2 =
"True", then Cell B2="RED")
Another variation is to have the value in a cell determine the new cell
location. For example, IF(D1="","", then cell A(Row Number D1)="Populated")
Solutions?
I'm looking to have a logical test in one cell that will populate a
different cell if true, or a third cell if false.
For example, the logical test located in cell A1: If (A2=3, then Cell B2 =
"True", then Cell B2="RED")
Another variation is to have the value in a cell determine the new cell
location. For example, IF(D1="","", then cell A(Row Number D1)="Populated")
Solutions?