View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Whois Clinton Whois Clinton is offline
external usenet poster
 
Posts: 38
Default Formula doesn't work unless hit enter again

Hi,
I have the formula below to calculate percentage of gains. It has been
dragged through approximately 70 rows. It has been working fine automaticall
calculating as I enter the data in columns K,L,M. However, today as I
continue entering data the formula does not automatically calculate. i have
to click the cell, place the cursor in the formula bar and then press enter.
i change nothing in the formula, but simply bringing it into formula bar and
pressing enter the formula then works.

Is it a fluke? I have tried reopening it but the problem persists.

Thanks in advance,
Clint



=((M27-K27)*100)/K27