Click here to Skip to main content
15,860,972 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I have an excel formula which is given below
IF(ROW()-ROW($AJ$3)<$AJ$3,"",SUMPRODUCT(OFFSET(AB512,0,0,-$AJ$3,1),OFFSET($AI$222,0,0,$AJ$3,1))/SUM(OFFSET($AI$222,0,0,$AJ$3,1)))

how to convert this formula into equivalent c# code?
there is any tool to convert this?
Posted
Updated 20-Aug-14 22:35pm
v2
Comments
Sergey Alexandrovich Kryukov 21-Aug-14 3:34am    
What would you possibly mean by "convert"? Until you precisely define it, the question won't make any sense. Better start with explaining your goal. Please use "Improve question".
—SA
Atyant Srivastava 21-Aug-14 4:58am    
First understand what your formula is doing in real time, and build your logic accordingly.
ZurdoDev 21-Aug-14 8:40am    
What do you mean by convert to C#? C# doesn't know what ROW is unless you are in context of an Excel file. In a DataTable it is totally different.

Your question makes no sense.
Bhavik_Patel 28-Aug-14 5:59am    
Don't know but you can take a look at this link
http://www.codeproject.com/Articles/17853/Implementing-an-Excel-like-formula-engine

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900