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