LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
skimna7
 
Posts: n/a
Default Equations Result in 0


Hi,

I have had these worksheets with varying equations ranging from all
sorts of complexity, from simple SUM and DATEDIF functions to triple IF
conditions. These worksheets have been working for months flawlessly,
however, recently when I do anything in my excel books, I have run into
quite the situation. Everytime I click on a cell with a formula or
function, and I press enter afterwards, the value returned becomes a
'0' instead of what value it should result in. Or if I decide I want to
change the formula to refer to another cell in part of the formula,
again the resulting value in the cell becomes a '0'. I dont understand
what is going on. Any insight would be extremely helpful.

Thanks!


--
skimna7
------------------------------------------------------------------------
skimna7's Profile: http://www.excelforum.com/member.php...o&userid=32708
View this thread: http://www.excelforum.com/showthread...hreadid=525389

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
spell number JAWAD CHOHAN Excel Worksheet Functions 1 December 12th 05 05:58 PM
Convert number into words Blackwar Excel Discussion (Misc queries) 4 December 2nd 05 12:05 PM
How to .. sbgvp Excel Discussion (Misc queries) 8 October 4th 05 09:16 PM
I NEED HELP with the SPELLNUMBER Function vag Excel Worksheet Functions 0 June 21st 05 08:17 AM
EXCEL:NUMBER TO GREEK WORDS vag Excel Worksheet Functions 1 June 15th 05 05:57 PM


All times are GMT +1. The time now is 12:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"