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