Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP!!! I need to make a simple formula!
I am going crazy trying to figure this out myself! All I want to do is use a
formula to do this: Add the first 4 columns together to get a total. Then subtract fromt he total to get a final balance. I will just be using simple numbers no decimals or anything complicated. A+B+C+D=SUM -F=Balance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP!!! I need to make a simple formula!
=SUM(A1:D1)-F1 entered in G1
Gord Dibben MS Excel MVP On Fri, 8 Jan 2010 09:49:02 -0800, teacher206 wrote: I am going crazy trying to figure this out myself! All I want to do is use a formula to do this: Add the first 4 columns together to get a total. Then subtract fromt he total to get a final balance. I will just be using simple numbers no decimals or anything complicated. A+B+C+D=SUM -F=Balance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP!!! I need to make a simple formula!
Assuming the numbers have been typed into cells A1,b1,c1,d1 and f1
=A1+B1+C1+D1-F1 or =SUM(A1:D1)-F1 best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "teacher206" wrote in message ... I am going crazy trying to figure this out myself! All I want to do is use a formula to do this: Add the first 4 columns together to get a total. Then subtract fromt he total to get a final balance. I will just be using simple numbers no decimals or anything complicated. A+B+C+D=SUM -F=Balance |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP!!! I need to make a simple formula!
In cell A 1 I have 1.
In cell B 1 I have 2. In cell C 1 I have 3. In cell D 1 I have 4. In cell E 1 I have:- =SUM(A1:D1) This returns a total of 10. In cell F 1 I have 6. In cell G 1 I have:- =(E1-F1) This returns a total of 4. The above seems to give you what you want. If you agree please hit Yes. Thanks. "teacher206" wrote: I am going crazy trying to figure this out myself! All I want to do is use a formula to do this: Add the first 4 columns together to get a total. Then subtract fromt he total to get a final balance. I will just be using simple numbers no decimals or anything complicated. A+B+C+D=SUM -F=Balance |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP!!! I need to make a simple formula!
So your formula is
A+B+C+D-F What exactly is the issue? (other than you had multiple = signs in your posted formula that were not necessary) -- HTH... Jim Thomlinson "teacher206" wrote: I am going crazy trying to figure this out myself! All I want to do is use a formula to do this: Add the first 4 columns together to get a total. Then subtract fromt he total to get a final balance. I will just be using simple numbers no decimals or anything complicated. A+B+C+D=SUM -F=Balance |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP!!! I need to make a simple formula!
All I want to do is use a formula to do this:
=SUM(A1:D1, -F1) Add the first 4 columns together... If it's really columns... =SUM(A:D, -F1) = = = HTH Dana DeLouis On 1/8/2010 12:49 PM, teacher206 wrote: I am going crazy trying to figure this out myself! All I want to do is use a formula to do this: Add the first 4 columns together to get a total. Then subtract fromt he total to get a final balance. I will just be using simple numbers no decimals or anything complicated. A+B+C+D=SUM -F=Balance |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP!!! I need to make a simple formula!
see responses to your posting in other newsgroups
-- Regards Roger Govier "teacher206" wrote in message ... I am going crazy trying to figure this out myself! All I want to do is use a formula to do this: Add the first 4 columns together to get a total. Then subtract fromt he total to get a final balance. I will just be using simple numbers no decimals or anything complicated. A+B+C+D=SUM -F=Balance __________ Information from ESET Smart Security, version of virus signature database 4756 (20100109) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4756 (20100109) __________ The message was checked by ESET Smart Security. http://www.eset.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
Make it Simple! | Excel Worksheet Functions | |||
Make formula more simple --- array? | Excel Discussion (Misc queries) | |||
Make it more simple or intuitive to do simple things | Charts and Charting in Excel |