excel formulas

[Guest]

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

 

[Bob Phillips]

To do what?

--
HTH

Bob Phillips

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

 

[Guest]

hi rick, what exactly you are lookinf for?



"ri ck" escreveu:

 

[Guest]

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.

 

[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

 

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