Hi guys

I have a pricelist with a stock column that shows the exact stock quantity of a product, however, my update query for my website only works with y and 0 values. 'y' means in stock and 0 means out of stock.

So basically, I need a formula for that column that says: If a value in this column is GREATER THAN 0, then that value changes to y
BUT, if a value in this column is equal to 0, then it simply stays 0.

Extra info: I am using Excel 2010

All help is appreciated.

Thanks
Seth