Changing value of another cell by a macro in some other cell

[jnb]

Hi All,


Regarding the following pseudo code:

Function in Cell A10:

=IF(AND(A1=9,B2=9) ; Change Value in Cell X; Change Value in Cell Y)

Is it possible to achive this somehow ? No VBA.

Thanks in advance.

JNB

 

[Jason Morin]

Formulas only return values to their calling cells - they
can't "change" the value in another cell. You need VBA or
else simply use a formula in cell X and cell Y.

HTH
Jason
Atlanta, GA