+ Reply to Thread
Results 1 to 3 of 3

Greater than or Equal to Formula

  1. #1
    Registered User
    Join Date
    08-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    16

    Exclamation Greater than or Equal to Formula

    In one column I have a list of numbers (0-xxx) which represent in and out of stock doors; (in stock is calculated by less than or equal to 1 is considered out of stock, anything above that is in stock), my question is is there a way that i can have a binary expression (0,1) or anything for that matter gives me a formula so that the second column can let me know if the store is in or out of stock? thanks!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,311

    Re: Greater than or Equal to Formula

    If you have a column where you want to show this (say col C) and your data is in col A, then maybe...

    =if(A1<2,"Out of Stock","")
    or
    =if(A1<=1,"Out of Stock","")

    An alternative would be to use Conditional Formatting to have the cell change color if an out-of-stock condition is met?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Greater than or Equal to Formula

    thanks! this did the trick!

+ 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. Greater Than - Less Than - Equal to.... formula help
    By dhue0715 in forum Excel General
    Replies: 7
    Last Post: 01-10-2012, 08:28 PM
  2. Formula for greater than or equal to
    By jsfisher in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-08-2009, 11:50 AM
  3. Excel 2007 : Formula Greater than or Equal
    By UnknownState in forum Excel General
    Replies: 2
    Last Post: 04-21-2009, 09:17 PM
  4. formula to workout equal to or greater than
    By wheelie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-01-2006, 08:15 AM
  5. Formula which is greater tahn or equal to zero
    By bruce2444 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-07-2005, 03:05 PM

Tags for this Thread

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