You go your way, I'll go my way. Biff's answer was a good solution, if you
don't like it, that's on you.

In regards to your comment, I notice you keep flip-flopping back and forth.
One moment, you criticize the formula, then you criticize the question, then
you criticize me(...You haven't written many workbooks for other people to
use...). Make up your mind which it is going to be.

And, as has been pointed out extensively throughout the community, no matter
what protections, error trapping, passwords, redundant calculations, etc. are
done in a workbook, any user can break anything. So I ask you, why bother
with error trapping at all?
--
** John C **