Thread: Formulas
View Single Post
  #8   Report Post  
Gord Dibben
 
Posts: n/a
Default

Dave

You still haven't shown us what is not happening for you.

Do the formulas show rather than the results?

Perhaps you have ViewFormulas checked in ToolsOptionsView?

Try hitting CRTL + `(above TAB key) to toggle on/off.

Perhaps the cells were formatted as text before you entered the formulas?

Format to General and F2 then <ENTER

Perhaps the formulas are not updating when values change?

ToolsOptionsCalculation. Check "Automatic".

Gord Dibben Excel MVP

On Mon, 6 Dec 2004 11:37:03 -0800, "Dave"
wrote:

All formula's adding, subtracting, dates
The spreadsheets/formulas work on other computers but not on mine.
How do I post a formula that's not working?
=(C4-B4)/0.04166667
=(today)

"Peo Sjoblom" wrote:

Post a formula that isn't working and what it does and wha you expect it to do

Regards,

Peo Sjoblom

"Dave" wrote:

I'm running MS Office XP Std
My formula's in Excel are not working properly. I've done a check for
updates with office on my pc. how do I fix this?
--
Dave