Home

Needing help with IF or IFS formula...

jasonryan78
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 

''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. 

 

 

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