I’m not too familiar with formulas in general and haven’t succeeded after reading many posts. I need to have a pre-filled selling price column under certain circumstances. I’m not sure if it’s possible to have many ranges as I’m requesting. The multiplying doesn’t need to happen in the same column, I just need to get the “x multiply by” number in a column first.
Here are the different circumstances in a table (with examples in the last 2 columns), and written out how I think they should be for a formula.
If PC is between these two numbers, then multiply by X.