Good afternoon all.
I already have a formula in the cell to look for a "y" and replace with "From Stock"
IF(ISNUMBER(SEARCH("y",Order!G4)),"FROM H&S STOCK",Order!C4)
and I now what to add a formulas like this to get the cell if zero make blank
IF(Order!C4=0,"",(Order!C4))
Ive tried to get my head round getting these to work together can anyone help?