Results 1 to 5 of 5

formula for true/false tolerance percent

Threaded View

  1. #1
    Registered User
    Join Date
    08-07-2009
    Location
    Bristow, oklahoma
    MS-Off Ver
    Excel 2007
    Posts
    2

    Unhappy formula for true/false tolerance percent

    Hi everyone I am new here and could use some help.

    Here is what I am looking for:

    I need to be able to get a true/false from a tolerance percent.

    Here is an example of what I am trying to do

    cell a2 is Nitrogen
    cell b2 is (Known gas%) 2.4800%
    cell c2 is (unknown gas%) 2.4963%
    cell d2 is =b2-c2 and I get the answer no trouble there. what I need is to take the answer in cell d2 and set a plus/minus 2% tolerance in cell f2 and get a true/false comparison.

    I hope that made some kind of sence Thanks in advance for any help.

    Geeve
    Last edited by geeve420; 08-07-2009 at 02:21 PM.

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