Forum Discussion
equation or function?
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"
Hellocrackatinnie01,
The value in Column C is the difference between Column A and Column B.
Formula
=A2-B2
Explanation
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.3
Enter 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"
Hello Olufemi7,
Thanks,
I was reading far to much into it and got a little frustrated, I didn't even consider dropping the degree's C. Then using custom format. Not a regular Excel user.
