how to update a cell?

A

alekm

Hi
is there any way I can automaticaly update cell with following formula

=IF(AND(L3<>0;M26<>0);M26*100000/L3;""

I want the cell to be updated when L3 is changed
I could use worksheet_chang event procedure but I want to find out if there is somethin
more simple
Than

alekm
 
M

macropod

Hi alekm,

The simple way is to ensure 'Automatic' is selected, under
Tools|Options|Calculation.

Cheers
 
Top