Forum Discussion
Solved
equation or function?
+0.3°c -0.1°c +0.4°c Looking for either an equation or function for this, in order to simply enter column A & B and have answer autofill. The number in column A is the constant number that I want c...
Hellocrackatinnie01,
The value in Column C is the difference between Column A and Column B.
Formula
=A2-B2Explanation
Column C represents the adjustment required for Column B to equal Column A. Subtracting B from A returns the correct positive or negative value automatically.Examples
0.3 - (-0.1) = 0.4
0.2 - (-0.2) = 0.4
0.3 - (-0.3) = 0.6
0.0 - (-0.1) = 0.1
-0.1 - 0.3 = -0.4
-0.2 - 0.0 = -0.2
-0.1 - 0.2 = -0.3Enter the formula in C2 and fill down.
Optional
If you want the temperature unit to display while keeping the values numeric, apply this custom number format
0.0"°C"
Thanks, all sorted still figuring this excel thing out.