# Greater than or Equal to Formula

1. ## 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!  Register To Reply

2. ## 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?  Register To Reply

3. ## Re: Greater than or Equal to Formula

thanks! this did the trick!  Register To Reply

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