[Date Index] [Thread Index] [Author Index]

Re: Multiple > and < calculations [great than & less than]

• To: mathgroup at smc.vnet.net
• Subject: [mg55318] Re: Multiple > and < calculations [great than & less than]
• From: "Valeri Astanoff" <astanoff at yahoo.fr>
• Date: Sat, 19 Mar 2005 04:45:20 -0500 (EST)
• References: <d1ebiu$ejk$1@smc.vnet.net>
• Sender: owner-wri-mathgroup at wolfram.com

[Not a mathematica problem!]
Suppose your data lie in column A of your spreadsheet.
In column B, I insert and copy down the following intermediate formula
:
(intermediate because you are not allowed to embed more than 6
formulas)

=IF(A1<999;"
";IF(A1<=1500;"A";IF(A1<=2500;"B";IF(A1<=3500;"C";IF(A1<=4500;"D";IF(A1<=5500;"E";"Z"))))))

In column C, I insert and copy down the final formula :

=IF(B1<>"Z";B1;IF(A1<=7000;"F";IF(A1<=10000;"G";IF(A1<=15000;"H";IF(A1<=20000;"I";IF(A1<=30000;"J";"K"))))))


Results for test data :

1
999	A	A
1000	A	A
1001	A	A
1500	A	A
1501	B	B
2500	B	B
2501	C	C
7000	Z	F
7001	Z	G
20000	Z	I
20001	Z	J
30000	Z	J
30001	Z	K
40000	Z	K
40000	Z	K


hth


Valeri