Purchase order value slot

[manisai]

Hi,

Can someone help me on this.

I need purchase value slot formula.

Example

PO Number PO Value Value < 1000 1001 to 2000 2001 to 5000 5001 to 10000

1 999 999
2 2400 2400
3 5025 5025
4 1750 1750

Thanks in Advance
Mani

[AliGW]

What's the question? What results are you expecting?

[manisai]

Hi

I need po value in the slot

Thanks

[AliGW]

What value in what slot? Your opening post is not clear - look at it. Would you be able to work out what you want if you didn't know???

[manisai]

Hi

Pls find attached file

Thanks

[AliGW]

In C2 copied across and down:

=IF(COUNT($B2:B2)=1,IF($B2 < CHOOSE(COLUMNS($C:C),1000,2000,5000,10000,50000),$B2,""),"")

[manisai]

Hi

Thanks it works but I need < 1000 also can you please include.

Thanks in Advance
Mani

[AliGW]

It does EXACTLY what you asked for already:

Excel 2016 (Windows) 32 bit

	A	B	C	D	E	F	G
1	PO NO	VALUE	< 1000	1001 to 2000	2001 to 5000	5001 to 10000	10001 to 50000
2	1	999	999
3	2	4570			4570
4	3	1570		1570
5	4	45000					45000
6	5	6370				6370

Sheet: Sheet1

Excel 2016 (Windows) 32 bit

	C
2	=IF(COUNT($B2:B2)=1,IF($B2 < CHOOSE(COLUMNS($C:C),1000,2000,5000,10000,50000),$B2,""),"")

Sheet: Sheet1