If I were doing this in Lotus, I'd either write a l-o-n-g if/then nested
formula, or create a lookup table. I'm assuming you have the same
options in Calc.
On 2/26/2006 7:55 PM, Jack Gates wrote:
I am trying to figure out how to create a formula that is probably complex. I
do not know what function to use and I do not understand much of the help
documentation that I have read in OOo 1.1.3
I want a cell (A2) to read the value of another cell (A1) and then put a value
in cell A2 after it has determined what group of value ranges that the value
in cell A1 belongs to.
Example:
A1 >= 0.01 but <= 20.00 then A2 = 5.75
A1 >= 20.01 but <= 40.00 then A2 = 6.50
A1 >= 40.01 but <= 80.00 then A2 = 8.50
A1 >= 80.01 but <= 120.00 then A2 = 10.50
A1 >= 120.01 But <= 160.00 then A2 = 11.95
A1 >= 160.01 But <= 200.00 then A2 = 12.95
A1 >= 200.01 But <= 300.00 then A2 = 15.95
A1 >= 300.01 But <= 400.00 then A2 = 17.95
A1 >= 400.01 But <= 500.00 then A2 = 19.95
A1 >= 500.01 But <= 749.99 then A2 = 21.95
A1 >= 750.00 then A2 = 0.00
I have no idea what formula to use or what function(s) to use. Will any one
be willing to help me by telling me what forumla and function(s) will work
and then point me to some complete information that will help me learn how to
set my formula up correctly so it will work?
Thank you for any help,
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
