Google Sheets - How to write a formula that minuses the selected cells from the top cell-CodePudding

Home > Software engineering > Google Sheets - How to write a formula that minuses the selected cells from the top cell

Google Sheets - How to write a formula that minuses the selected cells from the top cell

Time：07-31

How would I do it so if I had a list of numbers, how could I get every number below A1 to be minuses from A1 and put next to that cell?

CodePudding user response：

What about this simple formula in A2 cell?

=INDEX(A1 B2:B6)

CodePudding user response：

Paste this in B2 or see the