I need a formula to have a blank cell instead of a "x" eg:
result
should be:
aa ab ac ad ae af ag ah ai aj ak al am an ao
2 6 3 6 2 5 17 20 15 205 18 6 3 6 2x 5
3 1 5 7 19 12 133 1 5 7x

the formula i used is: =IF(AF2=42,AA2&""&"x",IF(AF2="","",AA2))
on row 3 there are blank cells (null string contains formulas ) when
I apply the formula to those cells it returns a "x" instead of a blank cell

can someone help please

bill gras