It appears that the copy and paste method of transfer from my online visa
statement was causing the problem. If I enter the value manually then the
formula will work. If I copy and paste then it will not work.

"Aussie Rob" wrote:

1 Shut down the computer and started again. No change to the problem.

Opened the file direct from "my documents menu" so no other file open.


Auto Calculation is on

Column goes all the way to Row 2 - Row 1 is the column Header "Restaurant"


"Ronald R. Dodge, Jr." wrote:

A few possible things could be happening.

If you have it in manual calculation mode, it obviously won't calculate
which could be caused by opening up a workbook that has manual calculation
set in it (if there is no other workbook already open when that one workbook
is opened)

If you purposely have it in manual calculation and press the F9 key, it
works for more simple calculations, but as calculations gets to be more
complex, it no longer works properly, so that's why I refuse to use the F9
function by itself within Excel. You can use Shift F9 to calculate just the
worksheet or Alt-Ctrl-F9 to force an entire calculation across all open
workbooks.


If you are putting in formulas and nothing is calculating properly, even
after pressing Alt-Ctrl-F9, then chances are, something may not be working
properly and generally when this happens, have to reboot the system.

The column where you putting the formula in may not be going all the way up
the column (if there are breaks in the column in between records), so be
careful with this aspect, especially if using something like subtotals.
When you first click on the cell, you can press Alt-= (That is to press and
hold the Alt key as you press the = [Equal] key), then within the range
highlighted, you may select the range or directly edit the range, which will
take you from Point mode to Edit mode of editing the formula in the cell.


--
Thanks,

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
"Aussie Rob" wrote in message
...
I am working on a financial spreadsheet and use the "IF" formula to place
information in a result column. =IF(F2="restaurant",C2,0)
This formula puts the value into the restaurant column but when I ask for
"autosum" for the resultant column it will not calculate. Any suggestions?