basically i have a sheet set up with 3 columns , 1st is price , 2nd postage , 3rd profit

now , in the profit column i have set the formula to subtract the postage from the price to give me the profit but where there is nothing in a row (no price , no postage) it still shows the profit as £0 but i want it to remain blank until i put something in that row

is it possible ??

i have all the cells formatted for currency (but it makes no difference whatever they are formatted for)

i am using Microsoft excel 2002

 

Did youy want the colum completely blank or just with the pound sign and no number ?

 

completely blank , i have found the "conditional format" thing but i would have thought i could put 'value less than 1 - leave blank ' but there isn't the option for blank

 

I'd expect the formula you have used in Column C is:
=A2-B2

To get a blank instead of a zero, use an IF command and make the formula:
=IF(A2-B2=0,"",A2-B2)

This can then be dragged down through each row to populate each.

 

that done the trick