ethel Well-Known Member Apr 10, 2008 #31 another one, if a cell is 0 and another one is not equal to 0, asterik in cell.
WouldBe Dislicksick Apr 10, 2008 #32 sarahluv said: another one, if a cell is 0 and another one is not equal to 0, asterik in cell. Click to expand... =IF(a1=0,b1<>0,"*","")
sarahluv said: another one, if a cell is 0 and another one is not equal to 0, asterik in cell. Click to expand... =IF(a1=0,b1<>0,"*","")
ethel Well-Known Member Apr 10, 2008 #33 WouldBe said: =IF(a1=0,b1<>0,"*","") Click to expand... Too many arguments apparently
ExtraRefined Better than you at everything you love Apr 10, 2008 #35 WouldBe said: Works but is messy and if you wanted to change the values to unequal ones you're stuffed. Click to expand... It's more concise, and more obfuscated. Therefore it's better
WouldBe said: Works but is messy and if you wanted to change the values to unequal ones you're stuffed. Click to expand... It's more concise, and more obfuscated. Therefore it's better