Placing Result In Different Cell

J

Jeff

I am trying to place the results of a formula in cell to another cell.
For example:
In B1: If (A1=6, C1=1, "")
It seems like it should work, but it will give me false in B1. How
can I achieve this result?
Thanks for your help!
Jeff
 
G

Gord Dibben

Jeff

Formulas can't return values to other cells. Only to the cell in which they
are entered.

If you want something in C1 you must write a formula there or resort to VBA,
perhaps Event code.
 
Top