This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 75%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDN%3C/text%3E%3C/svg%3E)
Is it possible convert Excel formula to SQL?
I mean like this site for convert VB.NET to C#.
I have to write lots of complicated excel function in format of SQL function like this:
=VLOOKUP(D4,Table25,MATCH(ِDATA!AB$3,Table25[#Headers],0))*IF(OR(E4="W",E4="KW"),(2*((G4*VLOOKUP(D4,Table25,3,0))*IF(D4="COF",SUM(H4,I4),MAX(H4,I4))*VLOOKUP(D4,Table25,2,0))+2*(F4*IF(D4="COF",SUM(H4,I4),MAX(H4,I4))*VLOOKUP(D4,Table25,2,0))),0)
and it is very hard and time consuming.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
An implementation of Visual Basic that is built into Microsoft products.
Additional SQL Server features and topics not covered by specific categories
Hi, @D N
Maybe you can do it through vba, but the basic functions of excel cannot be implemented.
Hi @D N ,
Just checking in to see if the information of OlafHelper-2800 was helpful. Please let us know if you would like further assistance.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Is it possible convert Excel formula to SQL?
No, only re-writing them manually. Excel formula and SQL are more then just different.