Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP
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})*E 26 now if the value in D27 is empty how do I show a null value in F27 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP
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})*E 26 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP
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 -- Regards, Peo Sjoblom "Rick Rothstein (MVP - VB)" wrote in message ... 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})*E 26 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP
Thanks for following that up... much appreciated.
Rick "Peo Sjoblom" wrote in message ... 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 -- Regards, Peo Sjoblom "Rick Rothstein (MVP - VB)" wrote in message ... 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})*E 26 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|