SQLTeam.com | Weblogs | Forums

Convert Excel formulas to SQL language automatically

Is it possible convert excel formula to SQL?

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.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/3bd3760e-2ccd-4d0d-8b46-9a20e668ab82/tips-for-converting-excel-formula-to-sql-server-expressions?forum=transactsql