Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
help on GPA formulas with null value
0 views
Skip to first unread message
JohnG
May 30, 2007, 5:59:02 PM5/30/07
to
I have a spreadsheet that has the following:
=LOOKUP(D26,{"a","a-","b+","b","b-","c+","c","c-","d+","d","d-","f","-";4,3.7,3.3,3,2.7,2.3,2,1.7,1.3,1,0.7,0,0})*E26
But if the colomn for Grade "D" and the coloum for Hours "E" are empty how
do I have column for Grade Points "F" show either empty or a "0"
JE McGimpsey
May 30, 2007, 6:14:41 PM5/30/07
to
0 new messages