Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

If Cell Contains Value Then Multiply Using #

99 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

2 Replies 2

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

Screenshot 2023-01-07 at 2.50.56 PM.png
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