Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
math formulaes arent working in excel
I use a spreadsheet to keep track of sick and vacation days and the
spreadsheet math seems to have stopped working. These are very simple addition and subtraction formulae's and I don't see anything out of the ordinary. -- Russ Johnson |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
math formulaes arent working in excel
Hi Russ,
What do you mean: "stopped working"? What happens? What do you see? What did you expect to see? Check: ToolsOptionsCalculation tabAutomatic -- Kind regards, Niek Otten Microsoft MVP - Excel "Russ Johnson" wrote in message ... |I use a spreadsheet to keep track of sick and vacation days and the | spreadsheet math seems to have stopped working. These are very simple | addition and subtraction formulae's and I don't see anything out of the | ordinary. | -- | Russ Johnson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
math formulaes arent working in excel
Try
Tools|Options|calculation select Automatic Click Ok Tap F9 Mike "Russ Johnson" wrote: I use a spreadsheet to keep track of sick and vacation days and the spreadsheet math seems to have stopped working. These are very simple addition and subtraction formulae's and I don't see anything out of the ordinary. -- Russ Johnson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
math formulaes arent working in excel
As Niek has said, automatic calculation may be turned off, so that
Excel will not perform calculation until prompted. Another common problem that presents itself this way is when another user accidentally replaces formulas with values by typing over them. On May 2, 4:09 pm, Russ Johnson wrote: I use a spreadsheet to keep track of sick and vacation days and the spreadsheet math seems to have stopped working. These are very simple addition and subtraction formulae's and I don't see anything out of the ordinary. -- Russ Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding up sheets that arent there yet | Excel Worksheet Functions | |||
Why isn't arent all my case notes transfering in a pivot report? | Excel Discussion (Misc queries) | |||
Excel Formulaes | Excel Discussion (Misc queries) | |||
I must be tired, because basic Math isn't working..... | Excel Worksheet Functions | |||
Why arent my blank cells moved to the end when I do a sort? | New Users to Excel |