Nested If

[shawn99michaels]

Hi all,

Would be grateful if I could have an insight of any of the excel gurus on how to get this formula working. The current set of data I have is as follows

1000 or more grade "G"
Between 900 and 999 "F"
Between 800 and 899 "E Super"
Between 700 and 799 "E Small"
Between 600 and 699 "D Super"
Between 500 and 599 "D Small"
Between 400 and 499 "c"
Between 300 and 399 "B"

I'm working on excel 2003 so can't get this to work if anyone knows how to do this I will be ever so obliged to you

Thanks

 

[MrKowz]

Try a LOOKUP:

=LOOKUP(A1,{0,300,400,500,600,700,800,900,1000},{"Unranked","B","C","D Small","D Super","E Small","E Super","F","G"})

 

[VoG]

Hi. Try like this

=LOOKUP(A1,{300,400,500,600,700,800,900,1000},{"B","C","D small","D super","E small","E super","F","G"})