[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: ownerwrimathgroup 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
Prev by Date:
Re: Writing result of "Do" in a single List
Next by Date:
Re: Distance from point to set
Previous by thread:
Re: Multiple > and < calculations [great than & less than]
Next by thread:
Re: Multiple > and < calculations [great than & less than]
