View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Vito
 
Posts: n/a
Default Formula correct, answer wrong


Perhaps you have calculations set to Manual.

Press F9 to confirm. Calculations should now work.


To set to automatic calcs:

Go to Tools|Options and in the Calculation Tab, set Calculation to
Automatic.

Click Ok.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=497619