Have a look in the help index for LOOKUP

--
Don Guillett
SalesAid Software

"Michell Major" <Michell wrote in message
...
My business has 10 clients who we charge at different rates; Ben = £10,
Bob
=£12 and Bill = £13. Adam is free therefore returns a blank (not FALSE
value) and if anyone has priority task it attracts a £10 premium. I can
only
'nest' 7 IF functions so ...
=IF(J3="Ben",10,IF(J3="Bob",12,IF(J3="Billl",13))) , AND(J3="p"+10) doesn't
work for me. Any help welcome