Here is the formula I'm using for the MAX. Is this the best method to use? Cells H6 and H7 are actually 0.00. I just have the custom format to hide 0.00.

=MAX(MOD(H2,1),MOD(H3,1),MOD(H4,1),MOD(H5,1),MOD(H6,1),MOD(H6,1),MOD(H7,1))

Data Range

H | |

1 | FRAC |

2 | 0.06 |

3 | 0.20 |

4 | 0.30 |

5 | 0.44 |

6 | |

7 | |

8 | 1 |

9 | 0.44 |

10 | 0.20 |

<tbody>

</tbody>