Masny argument Formula

M

Michell Major

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
 
S

Suresh Sadanandan

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 structure:
Index(sheet 2!b1:b10,match(d1,sheet2!a1:a10),0))

this will do it much more efficiently.
Regards,

Suresh
 
Top