Excel question.

[.:SAmSuNG:.]

Hi there I'm having trouble trying to find a way to do this.

Basically in excel a supplier provides a list of products with the attribute on each row either in stock or out of stock. Now the software my shop uses needs a number to calculate stock instead of the text in or out of stock.

Is there anyway in excel I could convert all the cells that say in stock to a cell next row over to them saying 2 (which would be avaliable quantity). Then all cells saying out of stock to be in the next column to 0?

I know its not a actual stock quantity but it means atleast one is avaliable.

Thanks.

 

[izzop]

Hi,

So you have a column that contains "In Stock" or "Out of Stock"?

In the column to the right you want to display a 2 if "In Stock" & a 0 if "Out of Stock"?

If so, this will do it: -

=IF(B3="In Stock",2,0)

Regards

 

[Bradley8988]