If Cell Contains Value Then Multiply Using #

[AnnieTacticomba]

Hello

I have a question about if cell contains "value", then multiply by # formula.  Is it possible to achieve the result I intended in column C?

Column A, single select = High, medium, low

Column B, numerical value = 5

Column C, formula, = If column A is high, column B with 0.7, If column A is medium, multiply Column B by 1, if column C is low, multiply by 2.

I am hoping I am able to multiply by a specific number under certain conditions.  Without manually typing in a value in the columns.  Just being able to select a value in the single select column makes the task and viewing easier. 

Thanks in advance!

Annie

[TheTimeSavingCo]

Hi Annie, yeah this is possible

Personally, I would use a formula field with the "SWITCH()" formula to show how much it's multiplying by as it makes things a lot clearer for me, but you could easily do away with it

Link to base.  You can get the formulas by duplicating the base

[AnnieTacticomba]

Hi Adam,

This worked out great!  Thank you so much for the tip! 

Thanks,

Annie