Could someone please help me - what is wrong with the below formula?
I put this into the cell for age group and I am always getting an error message as per below;
I realise this isn't the full formula but i would to try it in pieces and then add to it if successful - I am stuck as i cant see where I am going wrong.
with your text
you use two apostrophes on each end (' and ') instead of one quotation mark character ("). Like
And you don't need IFS, simple IF is enough. In both better to add FALSE condition.
Thank you very much, I appreciate you taking the time to assist.