London,

What Morrigan is saying to you is that a percentage, (at least under 100%),
is less than 1 so when you format the cell as percentage if divides anything
that you (then) enter into it by 100. He also pointed out that in your
formula there is no provision for the percentage being 50% or less. To
accomodate that make Morrigan's formula something like:

=IF(G60.9,"Excellent",IF(G60.75,"Very
good",IF(G60.6,"Good",IF(G60.5,"Could do Better","Unacceptable"))))

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk
"London" wrote in
message ...

yeah - i just through the amounts in to get it working.
It seems ok until I format the cell as a % then it just returns FALSE


--
London
------------------------------------------------------------------------
London's Profile:
http://www.excelforum.com/member.php...o&userid=25363
View this thread: http://www.excelforum.com/showthread...hreadid=389411