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 c...
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.