this is my formula
=IF(ISNUMBER(SEARCH("Lilac",G21)),150)+IF(ISNUMBER(SEARCH("Red",G21)),-50)
it returns a 0 , what do i need to add to it to return a blank cell instead ?
thanks in advance
this is my formula
=IF(ISNUMBER(SEARCH("Lilac",G21)),150)+IF(ISNUMBER(SEARCH("Red",G21)),-50)
it returns a 0 , what do i need to add to it to return a blank cell instead ?
thanks in advance
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks