Results 1 to 2 of 2

Please HELP!! Giving wrong answers!

Threaded View

  1. #1
    Registered User
    Join Date
    03-16-2005
    Posts
    4

    Red face Please HELP a.s.a.p.!! Giving wrong answers!

    Okay I am trying to get Ms Excel to calculate the following function:
    =(Q3-0.16)/(4.98-0.16) so I can use it to calculate a large number of data where initially Q3 = 0.16.

    Surely 0.16-0.16/anything = zero, however, Ms Excel is calculating this to be 0.001014684!!

    And also it is calculating the rest of my data wrongly using this formula???

    Any ideas???? Is it because I have excel set in the wrong calculation mode?? How do I get around this?

    Any help would be much appreciated!!!

    Lloyd Owens
    Last edited by lloydowens; 03-16-2005 at 10:31 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1