Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I set up a formula using number ranges as the arguments
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? |
#2
|
|||
|
|||
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. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Ballykea" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
I a formula that outputs the number of occurances of a specific t. | Excel Discussion (Misc queries) | |||
How do I enter a formula in a cell so that letters= a number i.e.. | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions |