Since it's a %, your formula should read

=IF(G60.90,"Excellent",IF(G60.75,"Very
good",IF(G60.60,"Good",IF(G60.50,"Unacceptable") )))



London Wrote:
Pupils attendances

=IF(G690,"Excellent",IF(G675,"Very
good",IF(G660,"Good",IF(G650,"Unacceptable"))))

G6 is a percentage - all I wanted to input was the total number of
lessons and the number attended


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=389411