Logo 
Search:

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: 3128

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)

=IF(C2="Editing",35*(D2),IF(C2="Web",85*(D2),IF(C2="Design",50*(D2),IF(C2="Proofreading",40*(D2),IF(C2="Application",185*(D2))))))

Any assistance would be greatly appreciated.

Thanks!

Share: 

 

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.