Help hiding cell value prior to info input

Hey guys, I have scoured endlessly to try and figure this out on my own, but nothing is working yet and it's driving me crazy. I'm trying to make a list with 9 questions with a "Yes, No, or Partial" answer with a 100, 50, or 0 attached to each answer, then at the end of the list, take the total sum of the points/answers and divide them by the amount of questions asked so that I can find the average, then assign a grade letter based on the number results. So far so good, my only problem is that before I start and begin answering any questions, the letter "A" shows up instead of just a blank cell like I want, at least until one or more questions have been answered.

This is my formula I'm using, and the grading is working properly, just not the show blank cell if nothing is answered yet part.

Please Login or Register  to view this content.

;the red coding is what I made to attempt to hide a value below 10, but it's not working and still shows an "A" grade before any questions have been answered.

Screenshot of the project for reference
\1

I very much appreciate any help anyone can offer with this issue. It's really not a major problem, I would just really like to figure it out. You'd think something like this would be incredibly simple to figure out.

Shulbocka welcome to the forum

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Just based on the formula you provided...
Instead of those nested IF's, I would create a small table to hold the values and scores...

	D	E	F
1	A	0
2		10	F
3		60	D
4		70	C
5		80	B
6		90	A

Then to get what you want...
D1=IF(D27="","",INDEX($F$1:$F$6,MATCH(D27,$E$1:$E$6)))

Thank you very much for your replies Fdibbins, I appreciate it a lot. I'm almost positive that what you suggested will work as you probably have a vast understanding of what you're talking about. However, I'm still new to Excel, and doing what you suggested about the table is over my head and not doable for me at this point. It does look like an extremely easy thing to do, but for some reason it's just not making sense to me. That said, I'm gonna study the crap out of what you just showed me to understand it, then implement it once it clicks for me. Your idea would be the best setup too as it would allow me to use pluses and minuses in my grading system as well, and not just standard A-F's. Also, thank you for explaining how to share/post a project file in post. I edited my original post to include the project file. Thanks again.

To try and explain a bit better...
Make up a small table (anywhere - I just put it in columns E and F). It can be as long or as short as you need it to be, and even once you have it created, you can still extend it (just adjust the ranges as needed)
The 1st column of data will contain the values/numbers you want to find (called the Criteria Range)
the 2nd column will contain the letters that you want each value to represent

Once you have that set up, then all you need to do is put a formula together that will take your criteria (the "score" you want to look up), search down the table, and return the relative letter for you. That formula would be what I suggested.
INDEX($F$1:$F$6,MATCH(D27,$E$1:$E$6))

To explain that (using a generic set of ranges and criteria)...
INDEX returns a value at the intersect (meeting) of a row and a column.
INDEX() syntax is =INDEX(range,row-num,column-num)
so something like =INDEX(A1:J10,3,5)
will return the contents of E3 (row 3, column 5)
Didnt even use MATCH, did we?

Now, to find the "3" or the "5", we would use the MATCH function...
MATCH syntax is...=match(criteria-to-find,column-to-search-in,0) 0 returns exact match
=MATCH("cc",A1"A10,0)
If "cc" is in A3, this will return 3
(to find the column number, we use the same thing, just change the range=MATCH(criteria-to-find,row-to-search-in,0)
'=MATCH("zz",A1:J1,0)
If "zz" is in E1, then this will return 5

Put them all together and you have...
=INDEX(A1:J10,MATCH("cc",A1:A10,0),MATCH("zz",A1:J10))