Sharepoint 2010 Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint 2010       RSS Feeds

Excel Formula in SharePoint Calculated Field/Column

  Asked By: Troy    Date: Sep 05    Category: Sharepoint 2010    Views: 3479

I have a formula that works perfectly in Excel 2007, but does not work in SharePoint 2010.

I have read that Excel formulas should work in SharePoint Calculated columns (but I've also read that the don't).

I am trying to calculate cost per hour based on a given task.

For example:
Editing Tasks = $35/hour
Proofreading Tasks = $40/hour
Web Tasks = $85/hour
Design Tasks = $50/hour
Application Tasks = $185/hour

The Excel formula is this:
(where C2 is the Task Type, D2 is Hours on Task)


Any assistance would be greatly appreciated.




No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Excel Formula in SharePoint Calculated Field/Column Or get search suggestion and latest updates.