how do I set up a formula using number ranges as the arguments

B

Ballykea

If cell figure is less than 287 use a.
if cell figure is between 287.01 & 400 use b
if cell figure is over 400.01 use c.
where a, b, & c are formula, should I be looking at Lookup table?
 
J

JulieD

Hi

how about
=IF(A1<287,formula_a,IF(A1<=400,formula_b,formula_c))
where
formula_a, _b & _c are the three different formulas you want to use.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Use TODAY() function as the criteria in a SUMIF formula 1
How to replace text with numbers? (formula) 4
Finding the proper style field and the numbered paragraph value within the style 0
Sumif does not work 2
Weighted % Complete calculation 1
Goal Seek with variable Set Cell 1
how to compare formula's values? 4

Top