SOLVED

If Condition with text and multiple options

%3CLINGO-SUB%20id%3D%22lingo-sub-1728218%22%20slang%3D%22en-US%22%3EIf%20Condition%20with%20text%20and%20multiple%20options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1728218%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3CBR%20%2F%3EI%20am%20new%20to%20formula%20and%20trying%20to%20create%20one%20that%20shows%20a%20different%20result%20in%20the%20column%20Score%20%22E%22%20every%20time%20a%20number%20is%20entered%20in%20the%20Stars%20column%20%22D%22.%3CBR%20%2F%3EIf%205%20%3D%20Gold%2C%20if%204%20%3D%20Silver%2C%20picked%20up%20from%20the%20B5%2C%20B4%2C%20B3%20cells%2C%20etc...%3C%2FP%3E%3CP%3EI'll%20be%20grateful%20if%20someone%20could%20help%20with%20the%20right%20formula%3F%3C%2FP%3E%3CP%3EThank%20you.%3CBR%20%2F%3EFreddy%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Excel%20Screenshot.jpg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F223022i2C1DC0C918795D70%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Excel%20Screenshot.jpg%22%20alt%3D%22Excel%20Screenshot.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1728218%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1728334%22%20slang%3D%22en-US%22%3ERe%3A%20If%20Condition%20with%20text%20and%20multiple%20options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1728334%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F813785%22%20target%3D%22_blank%22%3E%40FreddyNoel%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20many%20ways%20to%20handle%20it%2C%20please%20find%20below%20you%20may%20construct%20your%20formula%20using%20VLOOKUP.%20your%20source%20data%20should%20be%20in%20ascending%20order%20to%20get%20the%20results.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DVLOOKUP(D4%2C%24A%249%3A%24B%2413%2C2%2CTRUE)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Snag_2c2ef009.png%22%20style%3D%22width%3A%20640px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F223024iB9010CD5210079F5%2Fimage-dimensions%2F640x341%3Fv%3D1.0%22%20width%3D%22640%22%20height%3D%22341%22%20title%3D%22Snag_2c2ef009.png%22%20alt%3D%22Snag_2c2ef009.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20is%20the%20sample%20file%20for%20your%20reference%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1728351%22%20slang%3D%22de-DE%22%3ESubject%3A%20If%20Condition%20with%20text%20and%20multiple%20options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1728351%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F813785%22%20target%3D%22_blank%22%3E%40FreddyNoel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EIf%20I%20may%20recommend%20you%20add%20a%20file%20(without%20sensitive%20data)%20to%20show%20your%20project%20instead%20of%20a%20picture.%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EYou%20have%20to%20consider%20that%20the%20helper%20has%20to%20make%20the%20effort%20to%20design%20the%20file%20that%20already%20exists.%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EThis%20is%20very%20tiring%20from%20the%20start%2C%20so%20it%20is%20always%20good%20to%20insert%20a%20file.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EThis%20way%20you%20will%20be%20helped%20faster%20and%20the%20helpers%20too%2C%20whereby%20they%20can%20give%20a%20faster%20and%20more%20tailored%20answer.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EThank%20you%20in%20advance%20for%20your%20time%20and%20effort.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-result-transliteration-container%20result-transliteration-container%20transliteration-container%22%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1728415%22%20slang%3D%22en-US%22%3ERe%3A%20If%20Condition%20with%20text%20and%20multiple%20options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1728415%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EThank%20you%2C%20Faraz%2C%20for%20the%20quick%20reply%20and%20awesome%20solution.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EI%20have%20learnt%20something%20and%20you%20made%20my%20day.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EBest%20regards%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EFreddy%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1728435%22%20slang%3D%22en-US%22%3EBetreff%3A%20If%20Condition%20with%20text%20and%20multiple%20options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1728435%22%20slang%3D%22en-US%22%3E%3CP%3E%3CEM%3EThank%20you%2C%20Nikolino%2C%20for%20your%20quick%20reply.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EMy%20apologies%20for%20inserting%20a%20picture%20instead%20of%20the%20file.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EThis%20was%20my%20first%20post%20and%20I%20am%20already%20learning.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EBest%20regards%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3EFreddy%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1728484%22%20slang%3D%22de-DE%22%3ESubject%3A%20If%20Condition%20with%20text%20and%20multiple%20options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1728484%22%20slang%3D%22de-DE%22%3EEverything%20is%20OK.%20You%20have%20received%20from%20Mr.%20Faraz%20Shaikh%20a%20proposed%20solution%20that%20suits%20you%2C%20as%20far%20as%20I%20have%20seen.%20I%20can't%20expect%20better%20than%20that.%3CBR%20%2F%3E%3CBR%20%2F%3ENevertheless%2C%20I%20would%20recommend%20adding%20a%20file%20(without%20sensitive%20data)%20the%20next%20time.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20your%20understanding%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1735145%22%20slang%3D%22en-US%22%3EBetreff%3A%20If%20Condition%20with%20text%20and%20multiple%20options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1735145%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3Band%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20both%20for%20your%20input%20and%20if%20I%20may%20ask%20one%20more%20favour%2C%20it%20would%20make%20my%20spreadsheet%20amazing.%20As%20per%20Nikolino%20recommendation%2C%20I%20attach%20a%20file%20for%20easier%20editing.%3C%2FP%3E%3CP%3EIs%20there%20a%20possibility%20to%20add%20to%20the%20%22%3DVLOOKUP(D9%2C%24A%2416%3A%24B%2420%2C2%2C1)%22%20a%20complementary%20formula%20that%20would%20make%20my%20Gold%20rating%20cell%20coloured%20Yellow%2C%20Silver%20rating%20cell%20coloured%20Grey%20and%20Bronze%20rating%20cell%20coloured%20Brown%3F%20The%20colour%20could%20either%20be%20the%20text%20or%20the%20fill-in%20cell.%3C%2FP%3E%3CP%3EThank%20you%20again%20for%20your%20amazing%20support.%3C%2FP%3E%3CP%3EBest%20regards%3C%2FP%3E%3CP%3EFreddyNoel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1736152%22%20slang%3D%22de-DE%22%3ESubject%3A%20If%20Condition%20with%20text%20and%20multiple%20options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1736152%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F813785%22%20target%3D%22_blank%22%3E%40FreddyNoel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EIn%20the%20inserted%20file%20you%20can%20see%20the%20formula%20in%20action.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIn%20German%3A%3C%2FP%3E%3CP%3E%3DIF%20ERROR(DVERWEIS(D10%3B%24A-16%3A%24B-20%3B2)%3B%22%22)%3C%2FP%3E%3CP%3Ein%20English%3A%3C%2FP%3E%3CP%3E%3DIFERROR(VLOOKUP(D10%2C%24A-16%3A%24B-20.2)%2C%22)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3ESo%20you%20no%20longer%20have%20an%20error%20message%20...%20if%20there%20is%20no%20value%20in%20D%20then%20E%20is%20also%20empty%3C%2FSPAN%3E%3C%2FSPAN%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20and%20would%20be%20happy%20to%20know%20if%20I%20could%20help%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1736678%22%20slang%3D%22en-US%22%3EBetreff%3A%20If%20Condition%20with%20text%20and%20multiple%20options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1736678%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAwesome!%20Thank%20you%20so%20much%2C%20Nikolino%20for%20this%20unsolicited%20tip%20which%20makes%20my%20spreadsheet%20look%20neat%20and%20so%20much%20more%20professional!%3C%2FP%3E%3CP%3EI%20had%20no%20idea%20one%20could%20do%20that%2C%20and%20again%20learnt%20something%20brilliant%20today.%3C%2FP%3E%3CP%3EI%20am%20still%20wondering%20if%20Excel%20can%20do%20the%20function%20of%20adding%20colour%20for%20my%20Gold%2C%20Silver%20and%20Bronze%20cells%3F%20Maybe%20that%20is%20not%20possible%2C%20and%20it%20would%20not%20be%20a%20problem%20if%20I%20cannot%20do%20that.%3C%2FP%3E%3CP%3EThank%20you%20again%20for%20your%20great%20knowledge%20and%20kind%20assistance.%3C%2FP%3E%3CP%3EBest%20regards%3C%2FP%3E%3CP%3EFreddyNoel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hello,
I am new to formula and trying to create one that shows a different result in the column Score "E" every time a number is entered in the Stars column "D".
If 5 = Gold, if 4 = Silver, picked up from the B5, B4, B3 cells, etc...

I'll be grateful if someone could help with the right formula?

Thank you.
Freddy

 

Excel Screenshot.jpg

15 Replies
Highlighted
Best Response confirmed by FreddyNoel (Occasional Contributor)
Solution

Hi @FreddyNoel ,

 

There are many ways to handle it, please find below you may construct your formula using VLOOKUP. your source data should be in ascending order to get the results.

 

=VLOOKUP(D4,$A$9:$B$13,2,TRUE)

 

Snag_2c2ef009.png

 

Attached is the sample file for your reference

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more

Highlighted

@FreddyNoel 

 

If I may recommend you add a file (without sensitive data) to show your project instead of a picture.
You have to consider that the helper has to make the effort to design the file that already exists.
This is very tiring from the start, so it is always good to insert a file.
This way you will be helped faster and the helpers too, whereby they can give a faster and more tailored answer.
 
Thank you in advance for your time and effort.
 

Nikolino

I know I don't know anything (Socrates)

 
Highlighted

Thank you, Faraz, for the quick reply and awesome solution.

I have learnt something and you made my day.

Best regards

Freddy

Highlighted

Thank you, Nikolino, for your quick reply.

My apologies for inserting a picture instead of the file.

This was my first post and I am already learning.

Best regards

Freddy

Highlighted
Everything is OK. You have received from Mr. Faraz Shaikh a proposed solution that suits you, as far as I have seen. I can't expect better than that.

Nevertheless, I would recommend adding a file (without sensitive data) the next time.

Thank you for your understanding

Nikolino
I know I don't know anything (Socrates)
Highlighted

@Nikolino and @Faraz Shaikh

 

Thank you both for your input and if I may ask one more favour, it would make my spreadsheet amazing. As per Nikolino recommendation, I attach a file for easier editing.

Is there a possibility to add to the "=VLOOKUP(D9,$A$16:$B$20,2,1)" a complementary formula that would make my Gold rating cell coloured Yellow, Silver rating cell coloured Grey and Bronze rating cell coloured Brown? The colour could either be the text or the fill-in cell.

Thank you again for your amazing support.

Best regards

FreddyNoel

 

 

Highlighted

@FreddyNoel 

In the inserted file you can see the formula in action.

in German:

=WENNFEHLER(SVERWEIS(D10;$A$16:$B$20;2);"")

in English:

=IFERROR(VLOOKUP(D10,$A$16:$B$20,2),"")

So you no longer have an error message ... if there is no value in D then E is also empty.

 

 

 

Hope I was able to help you and would be happy to know if I could help you.

 

Nikolino

I know I don't know anything (Socrates)

 

Highlighted

@Nikolino 

Awesome! Thank you so much, Nikolino for this unsolicited tip which makes my spreadsheet look neat and so much more professional!

I had no idea one could do that, and again learnt something brilliant today.

I am still wondering if Excel can do the function of adding colour for my Gold, Silver and Bronze cells? Maybe that is not possible, and it would not be a problem if I cannot do that.

Thank you again for your great knowledge and kind assistance.

Best regards

FreddyNoel

 

Highlighted

@FreddyNoel 

Here is the file with the desired colors.

At the same time information on how to do conditional formatting in Excel

Use conditional formatting to highlight information

https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60...

 

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Highlighted

@Nikolino 

Hello, Nikolino,

Sorry for my late acknowledgement as I had a busy day.

FANTASTIC! I am in awe by your knowledge and kind contribution to making my spreadsheet an absolute gem.

I would not have been able to do it without your help.

The link to the Conditional Formatting is brilliant and very clear.

A million thanks again.

Best regards

FreddyNoel

Highlighted
I was pleased to be able to help you.
I wish you a nice day / night

Nikolino
I know I don't know anything (Socrates)
Highlighted

@Nikolino 

Hello Nikolino,

I am stuck again after finding out that I made a mistake with my ratings.

If you can help again, please, I would be much grateful.

In the column Total M, each member's Total should be the sum of the TWO HIGHEST Scores ONLY, out of 3 marks.

For example, Member 1 Total should be 1.25 and Member 2 shall be 2.50

I have tried but lamentably failed to find the right formula.

Thank you if you can offer a solution.

Best regards

Frederic

 

 

Highlighted

@FreddyNoel 

Add this formula into cell M4 and drag the cell down (to the next cell, etc.)

 

See the attached file.

 

German formula:

=KGRÖSSTE(J4:J6;1)+KGRÖSSTE(J4:J6;2)

 

English formula:

=LARGE(J4:J6,1)+LARGE(J4:J6,2)

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Highlighted

@Nikolino 

A million thanks again, Nikolino.

You are a Wizard, doing magic with Excel.

Best regards

Frederic

Highlighted
Your welcome
I was pleased to be able to help you.

Nikolino
I know I don't know anything (Socrates)