Using a cascading if

[RICKYBORGES]

I need to return a rank from 1 through 5 if the nswer to a formula in a different cell is a certain percentage like
100% = 1
99% = 1
98% = 1
97% = 2
96% = 3
95% = 4
and 94%and under = 5 this is what i came up with but its not working!!

=if(and(ab5/(ab5+ac5+ad5+ae5))>98%,(ab5/(ab5+ac5+ad5+ae5))<100%,1,if(ab5/(ab5+ac5+ad5+ae5))=97%,2,if(ab5/(ab5+ac5+ad5+ae5))=96%,3,if(ab5/(ab5+ac5+ad5+ae5))=95%,4,if(ab5/(ab5+ac5+ad5+ae5))<94%,5,"damn")


please help

[Pete_UK]

I think you need something like this:

=if(ab5/(ab5+ac5+ad5+ae5)>=.98,1,if(ab5/(ab5+ac5+ad5+ae5)>=.97,2,if(ab5/(ab5+ac5+ad5+ae5)>=.96,3,if(ab5/(ab5+ac5+ad5+ae5)>=.95,4,5))))

Hope this helps.

Pete