Results 1 to 4 of 4

formula that checks a cell for equal or less value

Threaded View

  1. #1
    Registered User
    Join Date
    12-02-2010
    Location
    Puerto Rico
    MS-Off Ver
    Excel 2010
    Posts
    2

    formula that checks a cell for equal or less value

    Hello. I'm trying to finish a school project using excel. What I am trying to create is a Inventory/To-Buy receipt/Sales Receipt.

    I already have almost everything ready BUT i am missing the knowledge of how to properly set up some functions I want it to have.

    Inventory: I have a Minimum quantity, Current Qty, and Required Qty cells. Min and Req Qty are set numbers using the vlookup formula with the Type of Product cell. As soon as I set the type of product it is, it automatically looks up the value of Min and Req Qty.

    Now Current Qty is set manually and here is the part where I need help. I have a To Buy cell that would check if the value is equal to or less that Min Qty cell and post itself on the To-Buy receipt with name(or product) and the amount to buy.

    I'm really new to excel that is why I resorted to ask for help. If this was the wrong section sorry.
    Last edited by NakedFury; 12-02-2010 at 10:46 PM. Reason: title name change

Thread Information

Users Browsing this Thread

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

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