View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Jim is offline
external usenet poster
 
Posts: 615
Default 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?