+ Reply to Thread
Results 1 to 8 of 8

Purchase order value slot

  1. #1
    Registered User
    Join Date
    09-11-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    40

    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

    Thanks in Advance
    Mani
    Attached Files Attached Files
    Last edited by manisai; 07-09-2019 at 04:51 AM. Reason: Attaching File

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,012

    Re: Purchase order value slot

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


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Registered User
    Join Date
    09-11-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    40

    Re: Purchase order value slot

    Hi

    I need po value in the slot

    Thanks

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,012

    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. #5
    Registered User
    Join Date
    09-11-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    40

    Re: Purchase order value slot

    Hi

    Pls find attached file

    Thanks

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,012

    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. #7
    Registered User
    Join Date
    09-11-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    40

    Re: Purchase order value slot

    Hi

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

    Thanks in Advance
    Mani

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,012

    Re: Purchase order value slot

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Populate my Purchase order from a list of Purchase Order numbers and their details
    By Carolbell44 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-11-2015, 07:14 AM
  2. How to connect purchase order and sell order with party ledger and daily day book
    By harisjawed86 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-26-2014, 11:36 AM
  3. Order entry and Purchase Order using VBA
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2012, 12:39 AM
  4. Macro Reqd to update Purchase order log, everytime a new purchase order is made
    By manthankanabar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-23-2012, 01:47 AM
  5. Replies: 10
    Last Post: 09-27-2012, 03:59 PM
  6. purchase order list & order number generator
    By podaf in forum Excel General
    Replies: 2
    Last Post: 06-28-2009, 06:02 PM
  7. [SOLVED] purchase order counter in excel purchase order template
    By Brandy@baoco in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-23-2005, 03:06 PM

Bookmarks

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