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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies