u/I_P_L

I have a sheet which has some data from the future already prefilled, but not everything, so some inputs are 0 for now. This leads to div0 on a bunch of fields calculations further down.

Ordinarily IFERROR would be fine, but I want to be able to see #N/A, #REF and so on still. Unfortunately there's no IFDIV0 like there is for IFNA.

Is there an elegant way to do this?

Back when I was on my Ps I drove a 2000 Ford Laser. Among all the other fond memories, I remember the thing made me feel like I was going fast, even though it ran a tiny 1.6L with a 4 speed slush box and was objectively quite slow. Even after driving quite a few genuinely fast cars since then I never had the same feeling of feeling like the car was fast even when it wasn't. This isn't a case of faulty memory either since I only sold it quite recently.

Any idea why that's the case?