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