Need Help with IF Commanda

[mrafiq44]

i have a 100 transactions - 50 with a debit and 50 with a credit amount in 2 separate columns, i want to identify where each of the amounts land up in the following categories -

[TABLE="width: 142"]
<tbody>[TR]
[TD]$0 - $2,500[/TD]
[/TR]
[TR]
[TD]$2,500 - $10,000[/TD]
[/TR]
[TR]
[TD]$10,000 - $50,000[/TD]
[/TR]
[TR]
[TD]$50,000 - $100,000[/TD]
[/TR]
[TR]
[TD]$100,000 - $250,000[/TD]
[/TR]
[TR]
[TD]$250,000 - $500,000[/TD]
[/TR]
[TR]
[TD]$500,000 - $1,000,000[/TD]
[/TR]
[TR]
[TD]>$1,000,000

Can someone please give me a code like "A' if it falls in the first category, then B - so i can do a pivot table to find number and mount of transactions for each amount.​

[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

 

[Joe4]

Something like this should work (for an entry in cell A1):

=LOOKUP(A1,{0,2500,10000,50000,100000,250000,50000,1000000,999999999},{"A","B","C","D","E","F","G","H","I"})

 

[jtakw]

Hi,

Also using LOOKUP, with a Table, you can change the parameters/results in the Table whenever needed:

Book1
	A	B	C	D	E	F	G
1	50001		D		0	2500	A
2					2501	10000	B
3					10001	50000	C
4					50001	100000	D
5					100001	250000	E
6					250001	500000	F
7					500001	1000000	G
8					1000001		H
Sheet71

Cell Formulas
Range	Formula
C1	=LOOKUP(A1,E1:E8,G1:G8)