blank cell instead of x

  • Thread starter Thread starter bill gras
  • Start date Start date
B

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
 
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))
 
Hi David Biddulph

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