Forum Discussion
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 column B to be ie: what must happen to column B to equal column A, as you can see in column C you add 0.4 so that column B equals +0.3. As seen below there is variation from positive and negative numbers in both columns therefore at any given time it will be adding or subtracting??
+0.2°c -0.2°c +0.4°c
+0.3°c -0.3°c +0.6°c
0.0°c -0.1°c +0.1°c
-0.1°c +0.3°c -0.4°c
-0.2°c 0.0°c -0.2°c
-0.1°c +0.2°c -0.3°c
anyone help me out, could save some considerable productivity time?
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"
4 Replies
Thanks, all sorted still figuring this excel thing out.
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"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.
You mean like this?
Just don't include the "°c" parts in the cells. That turns it all to texts and it becomes difficult to calculate with texts. You can always use a custom format to display the numbers with the °c suffix.
