Thread: excel formulas
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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.