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

  • Thread starter Thread starter jnb
  • Start date Start date
J

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
 
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
 
Back
Top