blank cell instead of x
 

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

blank cell instead of x
 

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


"bill gras" wrote in message
...
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

blank cell instead of x
 

Hi David Biddulph

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


"David Biddulph" wrote:

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


"bill gras" wrote in message
...
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


.