excel formulas

R

ri ck

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
 
B

Bob Phillips

To do what?

--
HTH

Bob Phillips

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

ri ck

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.
Click to expand...
Calibration Device accurate to +/- 1 Percent of reading.
 
G

Gord Dibben

=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
 
B

Bob Phillips

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)
 
Top