Hey everyone.

Thhis formuls works ok but I just noticed that it will still leave a % in
the destination cell (L13) even when one or more entries are made into the
cellsAI13, AW13, BI13, BW13, CJ13 ie: I don't want anything to appear in L13
unless all of the cells mentioned have a value in them.

Chers
David

Roger if your out there HELP!

=IF(OR(AI13="N",AW13="N",BI13="N",BW13="N",CJ13="N ",AI13="R",AW13="R",BI13="R",BW13="R",CJ13="R"),"" ,SUM(AI13/100+AW13/100+BI13/100+BW13/100+CJ13/100)/5)