Needing help with IF or IFS formula...

New 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 


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. 



Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies