HELP

J

JohnG

I have a spreadsheet set up for GPA but how do I enter a null value? I have
the formula set up as (which shows in F26)

=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,.7,0})*E26

now if the value in D27 is empty how do I show a null value in F27
 
R

Rick Rothstein \(MVP - VB\)

I have a spreadsheet set up for GPA but how do I enter a null value? I
have
the formula set up as (which shows in F26)

=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,.7,0})*E26

now if the value in D27 is empty how do I show a null value in F27

Could you do your formula this way?

=IF(ISBLANK(D26),"",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})*E26)

Rick
 
P

Peo Sjoblom

That will work if D26 is truly empty but if D26 has a formula and a null
string like "" then it won't work, then one might want to use

=IF(D26="","",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})*E26)

which will work in both cases
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top