How do I place conditions on which multiplier to use?

[banestyrelsen]

Hi all,

I can't figure out which formula to use and would really appreciate some help. I have a basic table with columns A and B, and I want column C to perform the following calculations.

If the text in A10 is "R", I want to multiply the value in B10 with the value in A1.
But if A10 = "K", multiply B10 by B1.
If A10 = "A", multiply B10 by C1.

What would be the easiest solution?

[shg]

Try =B10 * CHOOSE(MATCH(A10, {"R","K","A"}, 0), A1, B1, C1)

[banestyrelsen]

Works great, thanks!

[shg]

Lucky guess, you're welcome