If value is over X, then change value to Y (How?)

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

Originally Posted by Søren Larsen

=IF(value>0;"y";0) and copy down.

Is that what you are looking for?

Thanks for the help, but unfortunately that gave me an error.

I think we will have to have an output column.

So the IF statement will be based on D2 and downwards, and will output the 'y's and '0's into an output column.

Thanks again for the help.
Seth

Done.

=IF(D2>0,"y",0)