Forum Discussion

crackatinnie01's avatar
crackatinnie01
Copper Contributor
Mar 05, 2026
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...
training
  • Olufemi7's avatar
    Olufemi7
    Mar 08, 2026

    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"

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Mar 07, 2026

crackatinnie01​ 

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.