Hi,

Am Mon, 16 Jun 2014 11:50:31 +0100 schrieb revpeachy:

=IF(G4="","",IF(G4<100%,1,IF(G4=100%,2,IF(G4=111 %,3))))

try:
=IF(G4="","",VLOOKUP(G4,{0,1;1,2;1.11,3},2,1))
or
=IF(G4="","",IF(G4<1,1,IF(G4<1.11,2,3)))


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional