function to populate a cell where formula is NOT located
I don't want to put the formulas is the 'destination' cells as that area is
very dynamic. I made an error in my first example, the value of false should
have been 'then Cell C2="Red"'.
I've had a little feedback from another source saying this is most likely
solved by VBA and not in functions or formulas.
"Gary''s Student" wrote:
In your first example, put a formula in B2 to test the value in A1.
In your second example, you could use a simple event macro to dynamically
test the value in D1 and set the appropriate cell in column A
--
Gary''s Student - gsnu201001
"Jim" wrote:
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?
|