excel formulas
 

i can't get my formula can some help

80 75.8 76.7 83.3 80.0 0.0
75 70.8 71.8 78.3 73.7 -0.5
70 65.9 66.8 73.2 68.6 -0.6
60 56.1 56.9 63.1 57.6 -1.0

excel formulas
 

To do what?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ri ck" <ri wrote in message
...
i can't get my formula can some help

80 75.8 76.7 83.3 80.0 0.0
75 70.8 71.8 78.3 73.7 -0.5
70 65.9 66.8 73.2 68.6 -0.6
60 56.1 56.9 63.1 57.6 -1.0

excel formulas
 

hi rick, what exactly you are lookinf for?



"ri ck" escreveu:

i can't get my formula can some help

80 75.8 76.7 83.3 80.0 0.0
75 70.8 71.8 78.3 73.7 -0.5
70 65.9 66.8 73.2 68.6 -0.6
60 56.1 56.9 63.1 57.6 -1.0

excel formulas
 

this is what i trying to do, when i change the actual the percentage will
change.


scale before min max actual percent. error
80 75.8 76.7 83.3 80.0 0.0
75 70.8 71.8 78.3 73.7 -0.5
70 65.9 66.8 73.2 68.6 -0.6
60 56.1 56.9 63.1 57.6 -1.0

+/- 1 Percent of full scale.
Calibration Device accurate to +/- 1 Percent of reading.

excel formulas
 

=SUM(A1:E4) will add up all the numbers in your sample of data.

If not what you need, perhaps you should post more information.


Gord Dibben MS Excel MVP

On Mon, 3 Jul 2006 12:04:01 -0700, ri ck <ri
wrote:

i can't get my formula can some help

80 75.8 76.7 83.3 80.0 0.0
75 70.8 71.8 78.3 73.7 -0.5
70 65.9 66.8 73.2 68.6 -0.6
60 56.1 56.9 63.1 57.6 -1.0

excel formulas
 

How does the percent error work out as -0.5 in row 2?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ri ck" wrote in message
...

this is what i trying to do, when i change the actual the percentage will
change.


scale before min max actual percent.
error
80 75.8 76.7 83.3 80.0 0.0
75 70.8 71.8 78.3 73.7 -0.5
70 65.9 66.8 73.2 68.6 -0.6
60 56.1 56.9 63.1 57.6 -1.0

+/- 1 Percent of full scale.
Calibration Device accurate to +/- 1 Percent of reading.