About SUBTRACT in R and Excel

how to decrement the values in the same row in sequence, e.g. 9, 8, 7, 6, 5. 6→5-6=-1, 7→-1-7=-8. I know how to do it in R. But how to do it in Excel.
Thank you!

equal sign, address of cell which is input, then an operation on it
= A1 - 1
will give you a value one less than whatever number value A1 contains

Excel formulas with examples (ablebits.com)

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.