Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

excel percentage formulas

Status
Not open for further replies.

flash22

Technical User
Feb 4, 2013
1
FR
calculating a FMEA i want to add a formula in the last columns of which gives me the percentage rpn reduced by.

can some one please supply me with the formula of wich i need to add to the last column??

Thanks
 
Hi,

Use the AVG() function for your range of values.

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
I'll take a wild guess that you want

(Initial - Final)/Initial

 
Duh! He did say percentage.

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top