Results 1 to 2 of 2

Thread: Formula to order an item based on sales and quantity on hand
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Sep 2013
    Posts
    65
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Formula to order an item based on sales and quantity on hand

    Hi,

    I would like to create a formula where if I have sold more than 6 quantities and I have less than 3 in stock, it would ask me to create an order for 12 quantities.

    Thanks in advance.

    Regards,
    Hiten

  2. #2
    Board Regular kweaver's Avatar
    Join Date
    May 2018
    Location
    La Jolla, CA
    Posts
    629
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula to order an item based on sales and quantity on hand

    Do you mean something like this?


    Excel 2010
    ABC
    1QTY On-HandSoldORDER
    21010
    32025
    428ORDER 12
    5120ORDER 12

    Sheet2



    Worksheet Formulas
    CellFormula
    C2=IF(AND(B2>6,A2<3),"ORDER 12","")


Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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