You are reading a single comment by @NotThamesWater and its replies.
Click here to read the full conversation.
-
I've probably overengineered it
You've not started to over-engineer it until your formula, at the very least, includes multiple nested if statements to validate the data and datatype in cell A1.
Real over-engineering would include purposefully circular references that fed back with auto-generated suggestions to correct the error.
NotThamesWater
Yes, I've probably overengineered it now. But I'm getting the right result so all good