Nested Function With Division - Receiving #VALUE! Function Error

Hello.

I have a basic formula nested formula in AU7. When I go to enter another formula in AV7 that pulls from AU7, I receive an Error of #VALUE! because of the "-" (hyphen) in AU7 I believe. Example: In AU7 I have a formula that reads =IF(SUM(AN7:AT7),SUM(AN7:AT7),"-")

I need a formula in AV7 that checks AU7 for a value, then if there is one, I need it to Divide AU7/AU20, and if there is no value (just "-"), then I need AV7 to also have "-" (hyphen). In both AU7 and AV7 formulas, I wish to have only a hyphen ("-"), instead of a 0, blank, or #DIV! error.

Thanks a bunch for your assistance.

Or:

=IF(ISNUMBER(AU7),AU7/AU20,"-")

Doesn't it return an error for everything? You've got 4 open brackets and only 3 close ones

It worked. You are awesome! Thanks a bunch. Deanna