Re: Why does my formula return zero?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


If both these formulas return FALSE...

=ISNUMBER(F2)

and

=ISNUMBER(K2)

...then that means that the numbers are not being recognized as true
numbers (numerical values). You'll need to coerce those values into
true numbers by following the procedure I outlined. If your program
crashes, try doing it a small section at a time. If you continue to
have problems, you can always email me a copy of your file and I'll see
if I can pinpoint the problem. If you'd like me to take a look at it,
you can email me at domenic22@xxxxxxxxxxxx


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10785
View this thread: http://www.excelforum.com/showthread.php?threadid=374096

.

Relevant Pages

  • Re: Word 2003/2007 crashes upon keyboard input
    ... Nothing wrong with the user profile... ... It crashes as a local and a domain ... "Terry Farrell" wrote: ... I also tried the (local - XPS) printer but still no luck... ...
    (microsoft.public.word.application.errors)
  • problem adding
    ... My spread sheet ... rvnwdr's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23903 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Project crashes on startup for one profile
    ... Perhaps un-install and re-install to repair any flawed files? ... I have an issue where when starting MS Project Pro, it crashes every time for one specific profile. ... Connecting to a local computer or another profile works fine. ...
    (microsoft.public.project)
  • need help with - time values...
    ... I would need the easiest way to find the time difference between the ... rvnwdr's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23903 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • RE: Formula counts incorrectly
    ... > I assume that it is only counting 5/5/2005 one time? ... > Could someone please modify this formula to work the way I want it to? ... > was's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=20211 ... Prev by Date: ...
    (microsoft.public.excel.misc)