Purchase order value slot

1. Purchase order value slot

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

Mani

2. Re: Purchase order value slot

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

3. Re: Purchase order value slot

Hi

I need po value in the slot

Thanks

4. Re: Purchase order value slot

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???

5. Re: Purchase order value slot

Hi

Pls find attached file

Thanks

6. Re: Purchase order value slot

In C2 copied across and down:

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

7. Re: Purchase order value slot

Hi

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

Mani

8. Re: Purchase order value slot

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1