Hey all
What i want is my Cell to disply a Blank cell if the Cell it Equals is Blank
Eg
If BB24 is Blank i want it to disply Nothing not a Zero=BB24
Hey all
What i want is my Cell to disply a Blank cell if the Cell it Equals is Blank
Eg
If BB24 is Blank i want it to disply Nothing not a Zero=BB24
=if(bb24="","","")
Not quite, Kevin.
=IF(BB24="","",BB24)
Thanks guys
Alternatively,
=IF(ISBLANK(BB24),"",BB24)
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks