Can I do multiple IF/OR statements?

[darkwing_duck]

I have a pricelist spreadsheet which displays my customers' cost.

Some customers get the same discount, but a lot get a different
discount off of list.

I'd like to have a cell calculate their cost based on their discount.

If I were to write something like what I'm thinking out, it would read
like this:

If "Customer" = Customer A or Customer B, then price *.99, else;
If "Customer" = Customer C, then price * .98, else;
If "Customer" = Customer D, then price *.97, else;
If "Customer" = Customer E, then price *.96, else;
If "Customer" = Customer F or Customer G or Customer H, then price *.9
.... and so on, and so on, and so on ...

Any suggestions?
Thanks.
Robert Brown

 

[davemcochrane]

Hi,
How many customers are you going to have? there is a limit of nested
ifs you can use, maybe many customers can be in one price catagory, or
discount catagory

 

[Niek Otten]

Hi Robert,

Use the VLOOKUP() function instead: much easier to read and simpler to
maintain.

Let's assume you set up a table in column B and C:

A .99
B .99
C .98
D .97
etc

With your customer in A1, enter this formula in A2:

=VLOOKUP(A1,B1:C8,2,FALSE)

This gives you the multiplication factor.