Hi again,

Am Mon, 16 Jun 2014 15:09:36 +0200 schrieb Claus Busch:

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

the conidtions will be calculated in the order of appearance in your
formula. And if a condition is true you get the expected output and
calculation ends.
If you write = then you have to start with the largest value. E.g, 115%
is larger than 100%. So you get 2 as result.


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