Excel Function Translator

Formula paste karein aur use Excel ki kisi doosri bhasha mein paayein — function names, argument separators, decimal commas aur TRUE/FALSE sab convert, seedhe aapke browser mein.

Formulas poori tarah aapke browser mein translate hote hain. Jo aap paste karte hain woh aapke device par rehta hai aur ArrayKit ya kisi aur ko kabhi nahi bheja jaata.

Banaya aur maintain kiya: Udit Agarwal

Excel Formula Explainer kholein

Excel Function Translator ke baare mein

Jo formula saathi ke English Excel par chalta hai woh German, French ya Russian copy mein paste karte hi #NAME? ke saath fail ho jaata hai, kyunki application function names, argument separator aur decimal mark ko local bhasha mein rakhta hai. Excel Function Translator formula ko aapke chune edition ke liye dobara likhta hai. Yeh formula ko token-by-token padhta hai, isliye quotes ka text, sheet names, cell references aur table columns ko kabhi chhua nahi jaata. Har function name nau bhashaon mein 150 se zyada core functions ki table se badla jaata hai, jahan edition ko chahiye wahan commas semicolons ban jaate hain, aur 1.5 1,5 ban jaata hai. Agar aapko source bhasha na pata ho to woh function names se pehchaan li jaati hai. Jo kuch yeh pakke taur par translate nahi kar sakta woh andaza lagane ke bajaye list kiya jaata hai, aur doosra tab poori name table rakhta hai. Kuch upload nahi hota.

Features

  • English, German, French, Spanish, Italian, Portuguese (Brazil), Dutch, Swedish aur Russian ke beech kisi bhi disha mein translate karta hai
  • Argument separators aur decimal points saath mein convert karta hai, isliye 1.5 aur comma list 1,5 aur semicolon list ban jaati hai
  • TRUE aur FALSE ko translate karta hai (WAHR, VRAI, VERDADERO, ИСТИНА aur baaki)
  • Quotes ka text, sheet names, cell references, named ranges aur table columns ko bilkul waise hi rakhta hai jaise type kiye
  • Auto-detect chunne par function names se source bhasha pehchaanta hai
  • Anjaane functions aur bina pakke translation wale naamon ko list karta hai, koi naya gadhta nahi
  • Nau bhashaon mein 150+ function names ki searchable table — kisi bhi naam par click karke copy karein
  • Poori name table ko CSV file ke roop mein apne reference ke liye download karein

Excel Function Translator kaise use karein

  1. Formula paste karein, ya example chips mein se ek chunein
  2. Source ko Auto-detect par rehne dein ya woh bhasha chunein jisme woh likha gaya tha
  3. Us Excel ki bhasha chunein jisme aap use paste karenge
  4. Translated formula copy karein, aur jin naamon ko chhua nahi gaya unke liye notes dekhein

Example

Input

English:  =IFERROR(VLOOKUP(A2,'Price List'!$A$2:$D$100,3,FALSE)*1.19,0)

Output

German:   =WENNFEHLER(SVERWEIS(A2;'Price List'!$A$2:$D$100;3;FALSCH)*1,19;0)
French:   =SIERREUR(RECHERCHEV(A2;'Price List'!$A$2:$D$100;3;FAUX)*1,19;0)
Russian:  =ЕСЛИОШИБКА(ВПР(A2;'Price List'!$A$2:$D$100;3;ЛОЖЬ)*1,19;0)

Names, separators, decimals aur TRUE/FALSE badalte hain; sheet name, range aur 0 nahi badalte.

Common errors aur troubleshooting

  • Translated formula paste karne ke baad Excel #NAME? dikhata hai. — Check karein ki target bhasha us edition se mel khati hai jisme aapne paste kiya, aur ki function us version mein maujood hai — XLOOKUP jaisa function purane releases mein naam kuch bhi ho, nahi milta.
  • Naam sahi dikhne ke bawajood Excel kehta hai ki formula mein samasya hai. — Argument separator bhasha ke saath-saath aapki regional settings ko bhi follow karta hai. US region mein chalne wala German-language Excel ab bhi commas chahta hai, isliye apna region badlein ya separators ko mel khane ke liye edit karein.
  • 1.5 jaise numbers text ya galat value ban jaate hain. — Decimal points sirf tab commas mein badalte hain jab target edition commas use karta ho. Agar result galat lage to target bhasha check karein aur dekhein ki aapki decimal mark setting usse mel khati hai.
  • Ek function ke baare mein bataya jaata hai ki uska koi pakka translation nahi hai. — Woh verified name lists se naya hai ya uska koi confirmed local naam nahi hai. Tool use jaisa type kiya waisa hi chhodta hai; use target Excel ke Insert Function dialog mein dhoondhein aur haath se type karein.

Aksar pooche jaane wale sawaal

Excel Function Translator kaun si bhashaon ke beech convert kar sakta hai?
English (US), German, French, Spanish, Italian, Portuguese (Brazil), Dutch, Swedish aur Russian. Nau mein se koi bhi source ya target ho sakti hai, isliye aap English se guzare bina seedhe German se French ja sakte hain.
Kya Excel Function Translator quotes ke text ya cell references ko chhuta hai?
Nahi. Yeh pehle formula ko tokenise karta hai, isliye quoted strings (escaped quotes samet), sheet names, A1 aur R1C1-style references, defined names aur structured table references bina badlav ke copy ho jaate hain. Sirf function names, TRUE/FALSE, separators aur numeric decimal marks dobara likhe jaate hain.
Translated formula commas ke bajaye semicolons kyun use karta hai?
Excel ke jin editions mein decimal mark comma hota hai woh arguments ke beech bhi comma nahi use kar sakte, isliye woh semicolon use karte hain. English arguments ke liye comma aur decimals ke liye point use karta hai. Translator dono marks ko saath badalta hai taaki formula valid rahe.
Kya Excel Function Translator kisi formula ki bhasha khud pata laga sakta hai?
Haan. Auto-detect ke saath yeh har bhasha ko pehchaane gaye function names aur semicolon separators dikhne ke aadhar par score karta hai. Jab formula sirf aise naam use karta hai jo kai bhashaon mein ek jaise hon, to woh bata deta hai ki kaun se candidates fit baithte hain aur aapko chunne deta hai.
Jab formula mein koi aisa function ho jo translator nahi jaanta, to kya hota hai?
Custom functions aur add-in names bilkul waise hi chhode jaate hain jaise type kiye gaye aur un naamon ki list mein dikhaye jaate hain jo translate nahi hue. Formula ka baaki hissa phir bhi convert hota hai, isliye aapko sirf bache hue haath se theek karne padte hain.
Translation table ke function names kitne bharosemand hain?
Table Microsoft ki published function-name translation lists ko follow karti hai aur naam tabhi shaamil karti hai jab woh pakka ho. Jahan kisi bhasha mein function ka confirmed naam nahi hai wahan cell khaali chhodi jaati hai, aur use istemaal karne wala formula andaza lagane ke bajaye report kiya jaata hai.

Related tools

  • Excel Formula Explainer — Koi bhi Excel ya Google Sheets formula paste karein aur har function aur argument ka aasaan bhasha mein step-by-step breakdown paayein.
  • Excel Formula Generator — Conditional sums, lookups, dates, text splitting ya ranking jaisa task chunein aur paste-ready Excel ya Google Sheets formula paayein.
  • VLOOKUP Formula Generator — Sahi VLOOKUP formula step by step banayein: IFERROR, exact ya approximate match, XLOOKUP aur INDEX MATCH alternatives aur live test.
  • INDEX MATCH Formula Generator — Left lookup, two-way lookup aur multiple criteria ke liye INDEX MATCH formulas banayein, live test table aur copy-ready output ke saath.
  • Excel Data Cleaner — Ganda spreadsheet saaf karein: spaces trim, case theek, blanks aur duplicates hatayein, dates aur numbers standardise karke .xlsx ya CSV export karein.
  • CSV to Excel — CSV ya TSV files ko browser mein formatted .xlsx workbook banayein: delimiter detection, header styling, column types aur kai sheets.
  • Excel to CSV Converter — Ek Excel workbook ki kisi bhi sheet ko delimiter aur date options ke saath saaf CSV mein export karein.

Excel & Spreadsheets ke aur tools

  • Excel VBA Macro Generator — Tasks ki library se ready-to-run VBA macros banayein (loops, blank rows hatana, sheets PDF mein export, mail aur aur bhi) apni ranges aur naamon ke saath.
  • CSV to Excel — CSV ya TSV files ko browser mein formatted .xlsx workbook banayein: delimiter detection, header styling, column types aur kai sheets.
  • JSON to Excel — JSON arrays ya nested objects ko Excel workbook mein badlein: flatten columns, har array ke liye sheet aur typed cells.
  • Excel Data Cleaner — Ganda spreadsheet saaf karein: spaces trim, case theek, blanks aur duplicates hatayein, dates aur numbers standardise karke .xlsx ya CSV export karein.
  • VLOOKUP Formula Generator — Sahi VLOOKUP formula step by step banayein: IFERROR, exact ya approximate match, XLOOKUP aur INDEX MATCH alternatives aur live test.
  • INDEX MATCH Formula Generator — Left lookup, two-way lookup aur multiple criteria ke liye INDEX MATCH formulas banayein, live test table aur copy-ready output ke saath.
  • Excel Formula Explainer — Koi bhi Excel ya Google Sheets formula paste karein aur har function aur argument ka aasaan bhasha mein step-by-step breakdown paayein.
  • Excel Formula Generator — Conditional sums, lookups, dates, text splitting ya ranking jaisa task chunein aur paste-ready Excel ya Google Sheets formula paayein.

Excel & Spreadsheets ke sabhi tools dekhein (9) · Saare tools