Cell Format

[Ryuujin]

Hey all

What i want is my Cell to disply a Blank cell if the Cell it Equals is Blank

Eg

Please Login or Register  to view this content.

If BB24 is Blank i want it to disply Nothing not a Zero

[Kevin UK]

=if(bb24="","","")

[Cutter]

Not quite, Kevin.

=IF(BB24="","",BB24)

[Ryuujin]

Thanks guys

[Ace_XL]

Alternatively,

=IF(ISBLANK(BB24),"",BB24)

[Kevin UK]

Not quite, Kevin.

=IF(BB24="","",BB24)

Sorry Cutter, I missed read it!
Jumped in without looking