finding deviation from specified point or target

[mangoman4]

I would like to find the deviation from a specified point or target that may not be within the data set

as an example if given the following data set

50,51,75,72,68,49,81,72,70,68

I may want to find the devaition from "40"

 

[VoG]

Try like this: formula in C2 copied down

Excel Workbook
	A	B	C
1	Value	Target	Deviation
2	50	40	10
3	51		11
4	75		35
5	72		32
6	68		28
7	49		9
8	81		41
9	72		32
10	70		30
11	68		28
Sheet2