ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   auto mathemtics (https://www.excelbanter.com/excel-discussion-misc-queries/158510-auto-mathemtics.html)

ron manring

auto mathemtics
 
when subtracting numbers in rows how do i get the answer to automatically
appear in the adjacent column?

Gord Dibben

auto mathemtics
 
In C1 enter this formula =A1-B1

With more detail perhaps something else could be devised.

Like what rows and how many cells and which column is adjacent?


Gord Dibben MS Excel MVP

On Sun, 16 Sep 2007 19:10:01 -0700, ron manring <ron
wrote:

when subtracting numbers in rows how do i get the answer to automatically
appear in the adjacent column?




All times are GMT +1. The time now is 12:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com