Search: | |||||

| ||||

Home » Forum » Sharepoint 2010 | RSS Feeds |

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!

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.

Related Topics:

- Calculated column - problem with formula
- Calculated Column using =LEFT() formula
- Setting the formula of a calculated field using the Object Model
- Calculated column formula
- Field is not available in selection box for calculated column
- Calculated Fields and the ID Column
- Date Operators for calculated fields in list columns
- Calculating column values from choice field
- How can I build a longer (7>)calculated formula using the =IF function
- Calculate field based on field in another list
- Filename field as a calculated field
- Calculated fields (Date Fields)
- Excel Formulas
- Convert excel formula to xsl for use in data form web part
- No Formula Bar in Excel Web Part
- Column IF formulas only nest seven deep.
- Data connection to Infopath from a calculated column in Sharepoint
- Calculated Counter column in sharepoint list
- SharePoint List Export To Excel - Multiple Choice fields
- Unable to update a the default formula of a calculated field?
- Syntax for a calculated field in a list?
- Getting a calculated Column from a list
- Calculated column question
- Calculated Columns - Creating a site template
- Calculated column only updates when list item is edited