Just Curiious - formula to add data to another cell

[DonW]

Just Curious folks:

Is it possible to have a formula in one cell, that can enter data into another cell based on criteria in 3rd cell?

Assume
A1 = Yes or No
B1 = formula - such as if A1 = Yes then C1 = 1 else C1 = 0
C1 = result of formula from B1

[Tony Valko]

A formula can not "push" a result to another cell.

A formula can only return a result to the cell that contains the formula.

[MrShorty]

As Tony indicated, in spreadsheet programming, you don't want to think of one cell "pushing" data into another. You want to think of a cell "pulling" data into itself. So in your example:

A1 = Yes or No
B1 is blank -- since it has no relationship between A1 and C1.
C1 = formula that chooses result. Because desired outputs are usually more than 1/0, I expect you will want an =IF() function: =IF(A1="Yes",1,0) http://office.microsoft.com/en-us/ex...926.aspx?CTT=1

[DonW]

Thanks all. I didn't think it could but wanted to make sure I hadn't missed something.

[Tony Valko]

You're welcome. Thanks for the feedback!