Skip to main content

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

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

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


Hi Adam,

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

Thanks,

Annie

Reply


Terms & Conditions