Masny argument Formula
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 |
Masny argument Formula
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 |
Masny argument Formula
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 |
All times are GMT +1. The time now is 07:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com