Can Excel do this?

  • Thread starter Thread starter Robbe Morris [C# MVP]
  • Start date Start date
R

Robbe Morris [C# MVP]

Excel formulas are not my strong suit as I don't work with them often.

Is Excel capable of using a formula to push a value into another cell?

For instance, can A1 have a formula that says if B1 = 1 then C1 = "stuff"?

I cannot use macros.

I'd prefer not to use a "pull" type scenario where C1 also needs
a formula to check if A1 is true or not.

Basically, I don't want to A1 to reference any other cells but B1
or C1 and I don't want B1 or C1 to reference anything but themselves.

If Excel cannot handle this specific task, just let me know and
I'll move onto some other solution.


--
Robbe Morris - 2004/2005 Microsoft MVP C#

Earn money answering .NET Framework
messageboard posts at EggHeadCafe.com.
http://www.eggheadcafe.com/forums/merit.asp
 
As i know:

You want to write a "function" in A1 that changes value of C1 but this is
not possible in excel. You should write a "sub" to do this. You may use the
worksheet change event.
 
Without VBA, PULL is the only option available to you within Excel. Neither
A1 or B1 would need to reference C1, but C1 would need to contain a formula
that referenced whatever cells determine it's outcome.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 
Using a formula, you will have to "pull" as you said in c1.
Else you must use a macro which could be automatic.
 
Hi Robbe,
You are used to programming solutions and you want Excel
to be programmed, you cannot do that without a programming
solution which in Excel is usually VBA.

If you think in terms of pulling values instead of pushing
values you can stick with formulas and do a lot of things,
but if you try to fight what Excel is designed to do you
can't win and will lead to a lot of frustration.
 
Makes sense. My application works with Excel formulas
outside of Excel. My users build analytical models via
our application. I was looking for a better way to
provide conditionally hiding/formatting cells via
various calc engines that support Excel formulas but
this process "can" take place outside of Excel.

Now that you all have confirmed that this isn't an
option, I can concentrate on building a
different solution.

--
Robbe Morris - 2004/2005 Microsoft MVP C#

Earn money answering .NET Framework
messageboard posts at EggHeadCafe.com.
http://www.eggheadcafe.com/forums/merit.asp
 
Back
Top