Home

What is formula =TT(field) and how does it work?

%3CLINGO-SUB%20id%3D%22lingo-sub-410138%22%20slang%3D%22en-US%22%3EWhat%20is%20formula%20%3DTT(field)%20and%20how%20does%20it%20work%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-410138%22%20slang%3D%22en-US%22%3E%3CP%3EI%20found%20a%20formula%20%3DTT(field%20code)%20in%20my%20spreadsheet%2C%20that%20is%20somehow%20converting%20number%20values%20into%20a%20letter%20showing%20level%20of%20service.%20But%20I%20can%20not%20find%20anywhere%20in%20the%20spreadheet%2C%20where%20does%20it%20take%20the%20value%20ranges%20from%20(like%20vale%201-4%20%3DA%2C%205-6%3D%20B%20etc)%20and%20I%20can%20not%20find%20any%20information%20on%20such%20a%20formula.%3C%2FP%3E%3CP%3ECan%20anyone%20help%20me%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-410138%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-411772%22%20slang%3D%22en-US%22%3ERe%3A%20What%20is%20formula%20%3DTT(field)%20and%20how%20does%20it%20work%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-411772%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F316370%22%20target%3D%22_blank%22%3E%40merreh%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ethis%20is%20not%20a%20built-in%20Excel%20function.%20It%20could%20be%20a%20user-defined%20function%20created%20with%20VBA%20or%20it%20could%20be%20from%20a%203rd%20party%20add-in.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
merreh
Occasional Visitor

I found a formula =TT(field code) in my spreadsheet, that is somehow converting number values into a letter showing level of service. But I can not find anywhere in the spreadheet, where does it take the value ranges from (like vale 1-4 =A, 5-6= B etc) and I can not find any information on such a formula.

Can anyone help me please?

1 Reply

Hello @merreh ,

 

this is not a built-in Excel function. It could be a user-defined function created with VBA or it could be from a 3rd party add-in. 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 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
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies