Formula ignoring blank cells & leaving formula cells blank

[snt107]

I'm trying to create a grade tracker (pictured below) , and I have 2 questions regarding that. (note that I am a complete excel newbie, so please thoroughly explain each step to solve these problems, if possible.)

1. how do I leave the cells in column "Grade"(F8-F14) that have "0%" in them blank until data is entered?

AND

2. what formula would I use to calculate my current grade percentage when there are empty cells in the "score" column?

If these questions don't make sense please let me know, and I will try to explain what I'm asking better. Thanks in advance for all the help!

SaveSave​

 

[FDibbins]

Hi, welcome to the board

1. how do I leave the cells in column "Grade"(F8-F14) that have "0%" in them blank until data is entered?

F8=if(D8="","",your-formula)

2. what formula would I use to calculate my current grade percentage when there are empty cells in the "score" column?

Perhaps...
=sum(D:D)/sumifs(E:E,D:D,"<>")

 

[FDibbins]

Also, never a good idea to post an email addy in a public forum (it appears in your pic)

 

[snt107]

thank you so much!! the formula for the first question worked perfectly! the formula for the current grade, did not, however

 

[FDibbins]

OK, I will take another look for you