Forum Discussion
jasonryan78
Jan 09, 2019Copper Contributor
Needing help with IF or IFS formula...
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...
SergeiBaklan
Jan 09, 2019Diamond Contributor
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.
- jasonryan78Jan 09, 2019Copper Contributor
Thank you very much, I appreciate you taking the time to assist.