So while my mate is on holiday, iv been put in charge of the office at his business... im redoing the invoice system in excell and was wondering how do you hide cells that are part of a sum but dont have any data in?

As in iv got a collum that changes based on a sum of two other cells, iv dragged the formula all down the collum and apart from the one I want, it displays £0.00. Ovbs cant have that one going to customers, so is there a way to hide cells unless values are entered?

Right click on the column you want to hide and click hide
If in doubt right click and it gives loads of options.

(From Mrs Grande)

or change colour of the text

But I want it to automatically show when data is entered... can that be done?

Use an IF condition. So if xyz,val if true,""

colin79666 said:

Use an IF condition. So if xyz,val if true,""

Click to expand...

Ok so whats the specific formula?

Have a look at the attached example I've knocked up.

Thanks I will do when im at home