Results 1 to 5 of 5

Unable to Identify Error in Formula

Threaded View

  1. #1
    Registered User
    Join Date
    07-03-2010
    Location
    Chennai
    MS-Off Ver
    Excel 2003
    Posts
    1

    Unable to Identify Error in Formula

    Hi.. All

    I need a help in a formula. I have a series of accuracy data ranging between 0 to 100 based on the accuracy line rates have to be calculated based on the below slabs.

    Range - Rate (pesos)
    Lines @ >=98% - 5
    Lines @ >=95-97.99% - 4
    Lines @ >=90-94.99% - 3
    Lines @ >=85-89.99% - 2
    Lines @ <85% - 0

    I tried the below 2 formulas but what i noted is that when the accuracy is 85, 90 and 95 wrongs pesos are displayed

    =IF(F2>97.99,"5",IF(f2>94.99,"4",IF(f2>89.99,"3",IF(f2>84.99,"2","0"))))
    =IF(F147>98.00,"5",IF(F147>95.00,"4",IF(F147>90.00,"3",IF(F147>84.99,"2","0"))))
    Last edited by questers; 07-04-2010 at 06:37 AM. Reason: Title Change requested by moderator

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