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.

1 Answer 1


Short Answer

Use the IF() function.


Assume that formula 1 is B2*10 and formula 2 is B2*100. The formula to be used is



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.