Jan 09 2019 03:43 PM
Could someone please help me - what is wrong with the below formula?
=ifs([@[Customer Age]]<25,''Youth(<25)'')
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.
Jan 09 2019 03:53 PM
with your text
''Youth(<25)''
you use two apostrophes on each end (' and ') instead of one quotation mark character ("). Like
"Youth(<25)"
And you don't need IFS, simple IF is enough. In both better to add FALSE condition.
Jan 09 2019 07:53 PM
Thank you very much, I appreciate you taking the time to assist.