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!
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
thanks! this did the trick!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks