How can I fix this formula so if none of the 5 cells in the range have a number value this formula doesnt give an error but displays a - instead. The 5 cells show a - when no value is them. J21 is the formula I am having the problem with

<tbody>

</tbody>

<tbody>

</tbody>

<tbody>

</tbody>

**Excel 2013**E | F | G | H | I | J | K | |
---|---|---|---|---|---|---|---|

20 | Grade | ||||||

21 | - | - | 87.00 | - | - | 87.00 | A |

<tbody>

</tbody>

Worksheet Formulas
<tbody> </tbody> |

<tbody>

</tbody>

Array Formulas
<tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.Note: Do not try and enter the {} manually yourself |

<tbody>

</tbody>

Last edited: