how to update a cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi alekm,

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

Cheers
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ignore cells that are blank 4
Average for a column to exclude zeros and numbers above 39000 3
Streamlining a long IF=(AND formula ?? 2
Pivot Table 1
Conditional Formatting Problem 2
Formula for value of a cell when the cell answer has comma's in it 2
hOW TO USE eXCEL FUNCTION 2
Mass Update! (Excel 97) 4

Back
Top