Spire.XLS for .NET is a professional Excel .NET component that can be used to any type of .NET 2.0, 3.5, 4.0 or 4.5 framework application, both ASP.NET web sites and Windows Forms application.

Thu Jan 06, 2011 6:16 am

What would be the correct syntax for this forumula in Spire.XLS for .NET? [5 + (10 * weight) + (6.25 * height) - (5 * age)] * basalmetab

rick.ben15
 
Posts: 4
Joined: Tue Dec 28, 2010 1:13 am

Tue Jan 11, 2011 3:37 am

What you have should work, but you could take it step-by-step if you want...

double answer = 5;
answer += weightcalc;
answer += heightcalc;
answer -= agecalc;
answer *= basalmetab;
8)
e-iceblue support
User avatar

iceblue support
 
Posts: 240
Joined: Tue Dec 21, 2010 2:56 am

Return to Spire.XLS

cron