| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Where no value, display "NA" - if statement?
Good morning all,
Issue: I use the following formula to display data: =SUMPRODUCT(--('Daily Reading Master Log'!B$3:B$211=DATEVALUE("02/01")),--('Daily Reading Master Log'!B$3:B$211<=DATEVALUE("2/28")),'Daily Reading Master Log'!BW$3:BW$211)/SUMPRODUCT(--('Daily Reading Master Log'!B$3:B$211=DATEVALUE("02/01")),--('Daily Reading Master Log'!B$3:B$211<=DATEVALUE("2/28"))) Problem: Where this calculation is performed on a set of data that has no values, I get the 'DIV/0' error. I understand why this occurs, however: Question: How can i add an 'IF' component to this equation, such that if the result of hte calculation is 'DIV/0, display 'N/A', rather than the DIV/0 error Many thanks in advance, -- Carlee |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
| My Column display as "numbers" instead of "alphabets" | Excel Discussion (Misc queries) | |||
| Format cell to display "Y" or "N"when entering a 1 or zero | Excel Discussion (Misc queries) | |||
| embedding "ISERROR" function into an "IF" statement | Excel Worksheet Functions | |||
| How do display a "+" or "-" sign when hiding columns? | Setting up and Configuration of Excel | |||
Threaded Mode
