HOW DO I CREATE A SUBTRACTION FORMULA
 

i HAVE A BEGINING BALANCE IN CELL I6, A NUMBER IN CELL F8 GETS ADDED TO THE
NUMBER IN CELL I6, THEN ANY NUMBERS PUT INTO CELLS D8 THROUGH D42 ARE
SUBTRACTED FROM THAT TOTAL NUMBER AND THE FINAL TOTAL SHOULD BE IN CELL I47.
I47 SHOULD BE A RUNNING BALANCE LIKE A CHECK BOOK

HOW DO I CREATE A SUBTRACTION FORMULA
 

Here you go

=I6+F8-SUM(D8:D42)

--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"MEDIC70736" wrote:

i HAVE A BEGINING BALANCE IN CELL I6, A NUMBER IN CELL F8 GETS ADDED TO THE
NUMBER IN CELL I6, THEN ANY NUMBERS PUT INTO CELLS D8 THROUGH D42 ARE
SUBTRACTED FROM THAT TOTAL NUMBER AND THE FINAL TOTAL SHOULD BE IN CELL I47.
I47 SHOULD BE A RUNNING BALANCE LIKE A CHECK BOOK

HOW DO I CREATE A SUBTRACTION FORMULA
 

THANK YOU SOOOO MUCH, YOU JUST SAVED WHATEVER HAIR I HAVE LEFT

"John Bundy" wrote:

Here you go

=I6+F8-SUM(D8:D42)

--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"MEDIC70736" wrote:

i HAVE A BEGINING BALANCE IN CELL I6, A NUMBER IN CELL F8 GETS ADDED TO THE
NUMBER IN CELL I6, THEN ANY NUMBERS PUT INTO CELLS D8 THROUGH D42 ARE
SUBTRACTED FROM THAT TOTAL NUMBER AND THE FINAL TOTAL SHOULD BE IN CELL I47.
I47 SHOULD BE A RUNNING BALANCE LIKE A CHECK BOOK