| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help on GPA formulas with null value
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})*E2 6 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" |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help on GPA formulas with null value
One way:
=IF(COUNT(D26:E26)=2,LOOKUP(...),"") In article , JohnG wrote: 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" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF says Null = Blank but Blank < Null | Excel Worksheet Functions | |||
| Truly Null | Excel Worksheet Functions | |||
| cell value based on null/not null in another cell | Excel Worksheet Functions | |||
| When value is NOT Null | Excel Worksheet Functions | |||
| Formulas (If linked data is not null, then insert "Complete" in ce | Excel Worksheet Functions | |||
Linear Mode
