Unable to Identify Error in Formula

[questers]

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"))))

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[royUK]

It's not my question!!!!

Please read the questions more carefully & don't answer questions that a moderator has requested a change to title etc

[Mazzaropi]

I´m sorry.

The answer was not to you.
I adressed wronged the answer. Only this.
It´s not necessary to be rude.

I tried to help our friend that has a problem.

[royUK]

Read the Forum Rules about ignoring moderators,I wasn't being rude.


Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc