Can Excel do this?

  • Thread starter Robbe Morris [C# MVP]
  • 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
 
S

serdar

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.
 
K

Ken Wright

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 :)
------------------------------­------------------------------­----------------
 
D

Don Guillett

Using a formula, you will have to "pull" as you said in c1.
Else you must use a macro which could be automatic.
 
D

David McRitchie

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.
 
R

Robbe Morris [C# MVP]

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



David McRitchie said:
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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Robbe Morris said:
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
Click to expand...
Click to expand...
 
Top