Hello

I am using Word 2000.

I have the following formula in cell B1:
=IF(A1="Alan",85,IF(A1="Glen",85,IF(A1="Tony",85,I F(A1="Trevor",47,IF(A1="Bob",47,IF(A1="Bobby",47,I F(A1="Andre",47,IF(A1="Clive",47,IF(A1="Claire",47 )))))))))

How do I edit the formula to 'combine' Alan, Glen & Tony (equalling '85') in
one part of the formula & all of the other names (equalling 47) in another
part of the formula (to simplify the formula & to avoid a nesting of more
than 7)?

Hope that makes sense.

Many thanks.

Rachael