teacher help

[Tim K.]

Well, her boyfriend anyway...
I'm making a grade spreadsheet with a sheet for each grading period for my
girlfriend to use and the letter grade output is linked to a template Word
file report card.
=IF(R2>89,"A",IF(R2>79,"B",IF(R2>69,"C",IF(R2>59,"D",IF(R2>0,"F")))))
The trouble is when there is no grade it returns the error #div/o thing
which messes up the report card. So the question is, is there a way to make
it return a blank if there are no grades?
Thanks!
T

 

[Paul B]

Tim, here is one way,
=IF(ISBLANK(R2),"",IF(R2>89,"A",IF(R2>79,"B",IF(R2>69,"C",IF(R2>59,"D",IF(R2

0,"F"))))))

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

 

[Tim K.]

Thanks so much, but would you believe than not one returns a blank cell?
It seems so obvious to me that there should be an easy way to return a blank
cell for linking to grade books or any application where you might not have
all the data for the first report, but apparently not.
I suppose I could link to 4 cards for each child so there are no "future"
grade periods but man that seems so convoluted.