PPRuNe Forums - View Single Post - Yet another Excel question..

27th Dec 2007, 19:40

#4 (permalink)

Jhieminga

Join Date: Mar 2002

Location: near an airplane

Posts: 2,802

Likes: 10

Received 60 Likes on 44 Posts

I would've gone for the IF statement as well, just slightly different:

IF(B1<>"";B1;"")

No need to put a space in there, Excel can identify an empty field this way and also leave the cell empty if B1 is empty

Reply