help on GPA formulas with null value

[JohnG]

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]

One way:

=IF(COUNT(D26:E26)=2,LOOKUP(...),"")