function to populate a cell where formula is NOT located
in [Functions]
|
Prev: Dynamic Table Problem
Next: SUMIF returns no value
From: Rick Rothstein on 4 Apr 2010 10:50 Formulas on a worksheet cannot push a value into another cell... they can only display their calculated value (text or number) in the cell they are located in. Putting formulas in what you refer to as the "destination cell" and having them determine what should be displayed in there is pretty much how spreadsheets work. Can you explain what you mean by "that area is very dynamic" and why you think this means you cannot place your formula there? Yes, VBA gives you much more flexibility, but from what you have described so far, I am having trouble seeing why you can't do this with simple worksheet formulas. -- Rick (MVP - Excel) "Jim" <Jim(a)discussions.microsoft.com> wrote in message news:8C01FEAF-D44F-4B37-9DED-B290576510D0(a)microsoft.com... > 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?
From: Bernd P on 5 Apr 2010 03:38
Hello Jim, One possible approach might be a conditional format. The Excel help will give you more detailed information on this. Regards, Bernd |