Making 'values yet to be entered' formula cell invisible?

[HereIAm]

Firstly, I appreciate that this is probably a ridiculously simple problem - but I have scoured the internet and help files for the last two hours with no luck, and am at my wits end.

I've set up a spreadsheet and it's working great, but I want the formula cells to be empty until the necessary values have been inputted.

The spreadsheet is for a diet I'm getting on, and i'll enter the values each week, then have the sum work various things out once they've been keyed in.

=SUM(G15:G23)/G2

Now however, the function cells are listing "#/DIV0!" - because the values (G15:G23) are yet to be entered. I'd like these cells to be blank or zero if this is possible.

Again, I realise that this is probably too simple a problem to bother you people with, but we all have to start somewhere eh?

 

[VoG]

Hello and welcome to MrExcel.

I think you're getting the error because G2 is empty. Try

=IF(G2="","",SUM(G15:G23)/G2)

 

[HereIAm]

Hello and welcome to MrExcel.

I think you're getting the error because G2 is empty. Try

=IF(G2="","",SUM(G15:G23)/G2)

Thanks a lot. Just used the same principle to fix all the other fields that were similarly affected.

Fixed my problem and learnt a bit about Excel in the process - all quite logical I suppose when you figure out the 'language' it uses.

Thanks again.