Calculating markups for multiple value ranges in a single formula in Excel/Sheets
Hello! I'm a relative newcomer to spreadsheet formulas. I'm trying to use one formula to create standard markups for items based on fixed cost ranges. I thought I figured out how to use greater and less than in a formula and how to nest them together for multiple values and calculations, but instead of getting a markup calculation, it just returns “False.” I'm not sure if my formula is flawed, if I'm using <>= properly, or what else might be wrong.
I included a chart of the markups below. And here’s the formula I tried based on what I read. It only lists the first two ranges, but once I get that working to calculate properly, I’ll add all 8 ranges into the formula.
E2 is the product cost. So the first range is for products that cost less than $12 with a markup of 4x, the second range is $12-$17.99 with a markup of 3.7x, etc.
I really appreciate any help!
Help Article Resources
Check out the Formula Handbook template!