Needing help with IF or IFS formula...

Copper Contributor

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.

2 Replies

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.

 

Thank you very much, I appreciate you taking the time to assist.