google sheets
I have Column A which I want to contain one of two formulas based on whether the value in column B is below a certain number.
For example, A2 should contain Formula 1 if B2 is less than 9.99. Otherwise, it should contain Formula 2.
I've seen how to do a lookup based on a table of values, but not conditionally if the reference value is above or below a certain amount. I suppose I could create a giant table with 10,000 values from 0.01 to 99.99, but there must be a better way to do this.
You can conditionally format based on another cell or column by selecting your cells, and making a conditional formatting rule for cells "Greater Than" the cell "A1" as shown below.
Sheets uses this as a relative reference that you're comparing the cell to the left of each cell in your selection.
The formula =A1+((A1*25)/100) can be written as =A1*1.25
Multiplying a number by 1.25 several times means multiplying it by a power of 1.25.
For example, =A1*1.25^10 returns 3539.025784, as you want.
In general, your formula could be like =A1*1.25^B1 where A1 has the original value and B1 has the number of upgrades.
Best Answer
Short Answer
Use the IF() function.
Explanation
Assume that formula 1 is
B2*10and formula 2 isB2*100. The formula to be used isReferences