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

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

Hi,

Use the index function as mentioned,

if you have a list of names, in column A range 1 to 10 then create a table
with the names and the different rates in another sheet say sheet 2, col A
with names & column B with the rates, then use the formula structu
Index(sheet 2!b1:b10,match(d1,sheet2!a1:a10),0))

this will do it much more efficiently.
Regards,

Suresh

"Michell Major" wrote:

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