# If Cell Contains Value Then Multiply Using #

394 2
cancel
Showing results for
Did you mean:  5 - Automation Enthusiast

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.

Annie

2 Replies 2  15 - Saturn

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  5 - Automation Enthusiast 