blank cell instead of x

[bill gras]

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

 

[David Biddulph]

Don't forget that any string, including your null string, evaluates to
greater than any number, so "">=42 is TRUE.
Perhaps you want your conditions in the opposite order?

Try changing
=IF(AF2>=42,AA2&""&"x",IF(AF2="","",AA2))
to
=IF(AF2="","",IF(AF2>=42,AA2&""&"x",AA2))

 

[bill gras]

Hi David Biddulph

Your suggestion works perfect . Thank You
Have a prosperous new year