Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
How do I create a certain type of Excel formula? | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
How do I create a 26 'tier' IF formula? | Excel Discussion (Misc queries) | |||
How to create specific formula | Excel Worksheet Functions |