I can't figure out how to make a clean error-free formula for this situation.
(I'll be using this same kind of formula hundreds of times, so I need the formula to be simple as possible to reduce the time for calculating.)
Any help would be greatly appreciated!

If A$78 is a number THEN A$78

If A$78 is 0 THEN -0.01

If A$78 is not a number THEN C$23

If A$78 is not a number AND If C$23 is 0 THEN -0.01

If A$78 is not a number AND C$23 is not a number THEN "No Data"