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

27th Dec 2007, 13:06

#3 (permalink)

cdtaylor_nats

Join Date: Feb 2003

Location: Scotland

Posts: 144

Likes: 0

Received 0 Likes on 0 Posts

You can do it with an if statement.

Say A1 is the cell you want a blank in if B1 is 0.00

put the formula =IF(B1=0.00," ",B1)

If B1 is 0 then A1 will be a space, if it isn't then A1 will equal B1

Reply