formula to return blank rather than a "0"

Originally Posted by Domski

Like this then:

=IF(ISNUMBER(SEARCH("Lilac",G21)),150,IF(ISNUMBER(SEARCH("Red",G21)),-50,""))

Dom

sorry didnt work, when i used this formula, i got a "150" placed in the cell?

to clarify the problem. the formula would go into say cell G22, when Cell G21 contains the text "Lilac" or "Red", it returns either a 150 if "Lilac" or "-50" if "Red" text is found. What happens though when it finds no text in cell G21 it shows a "0" in G22, i want it to give a blank cell instead.

thanks