Question about Business & Productivity Software

10 Answers

In Excel adding positive and negative numbers

In adding a column of numbers what is the formula for writing the negative numbers

Posted by on

  • Goji20 Apr 02, 2008

    Sorry but that didn't seem to work, here is what I am tying to do $ 8,700.00
    0.00
    0.00
    $11,029.19
    "-$15,407.79"


    The total should be $4,321.21
    With your formula it didn't work for me

  • Goji20 Apr 02, 2008

    In Excell I am adding a a column of numbers
    $ 8,700.00
    $ 0.00
    $15,407.79.......Negative number
    $11,029.19
    Total should be $4,321.40
    One perwon said "-" before the number it didn't work can some one give me the correct formula for adding in the negative number?

×

10 Answers

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    President:

    An expert whose answer got voted for 500 times.

  • Master
  • 2,267 Answers

Here is picture with the formula and calculation.

In Excel adding positive and negative numbers - 04ed606.jpg

Posted on Apr 02, 2008

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 871 Answers

In Excel adding positive and negative numbers - 779_s.gif

One column contains mixed values of positive and negative numbers, needs to be
Separated into two columns, in the first column positive values in second column negative values.
Finally, add a formula to return running balance along the cells in a third column.

Solution:

Steps 1- Into cell B2 enter the formula:
=IF($A2>=0,$A2,"") and then copy the formula down to all cells in the range of data of column A.

Steps 2- Into cell C2 enter the formula: =IF($B2="",$A2,"") and again copy the formula down.

Steps 3- Into cell D2 enter the formula: =SUM(A2:B2).

Step 4- Into cell D3 enter the formula:=D2+SUM(A3:A3) and copy the formula down the remainder of the range.

Posted on Apr 02, 2008

  • earl norman llanera
    earl norman llanera Apr 02, 2008

    well,



    heres my pic for this






    select who your gonna fixya man...

  • earl norman llanera
    earl norman llanera Apr 03, 2008

    select your expert already...:)

×

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Business & P... Master
  • 13,433 Answers

Hello, Im trained in excel.

Here is how enter your calculation type exactly
8700
0
-15407,79
11029,19
Now press the function button witch calculates the above cells
it should now read
4321,40

note , instead of .
no , middle of number. excel will automatically add them if setup correctly.

If you need more asistance, let me know. Good luck.
Im trained in all office products.

Posted on Apr 02, 2008

  • Ekse Apr 02, 2008

    Im also trying to up my rateing to guru level, if I solved your problem please rate my suggestion as fixya!



    Thanks alot!

×

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 652 Answers

Yes,


  1. Select the column. (click on top of the column it will select)
  2. Right Click and select Format Cells.
  3. Select Currency in Category then press OK
In Excel adding positive and negative numbers - b6298df.gif Now just type your Numbers i.e. 571 for $571 and -650 for -$650 and sum using the normal way.

That is Select the Cells which you want to SUM and Press Alt+=

This will bring the total just below the selected cells.

Thanks
Iqbal

Posted on Apr 02, 2008

  • Iqbal Husain
    Iqbal Husain Apr 02, 2008

    see in my solution:

    After making entry as i told:




    And then I pressed Alt + = and after that see the screen




    The values are automatically summed in the cell A7.

    Please try it your self. And let me know your feed-bak.



    Thanks

    Iqbal

×

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 818 Answers

I make an example
a1 = $11,029.19
a2 = -$15,407.79
a3 =SUMA(A1:A2)
Sergio
if you explain corretly i send you the correct formula.
Sergio

Posted on Apr 02, 2008

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    MVP:

    An expert that got 5 achievements.

    Master:

    An expert who has achieved Level 3.

    Sergeant:

    An expert that has over 500 points.

  • Master
  • 461 Answers

Well not sure sure what you are trying to do by try this

cell B5 put in number : 10
cell B6 put in number : -2
cell B7put in formula : =B5+B6
The answer should read : 8 in cell B7

Posted on Apr 02, 2008

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 790 Answers

Hello ,

CLICK HERE for the complete instructions

Posted on Apr 02, 2008

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Master
  • 4,234 Answers

With the box format set up as $$, you should be entering just the number as -15407.79. The format will change that to either ($15,407.09) or -$15,407.79. In either case, you should not enter anything but the minus sign and the digits. If you are seeing anything else, please post the format definition for that cell and, if possible, a screen shot of that part of the grid.

Dan

Posted on Apr 02, 2008

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Business & P... Master
  • 19,396 Answers

You need to set the cells as value, and the $ sign will come automatically. If you type '$' by yourself the software will recognize the value as char string, and not consider -.


select the cells you want to pus |$ inside.

click richt button of mouse and select 'format cells'

In Format cells box set Category to Currency.

Now write - sign in front of the number, it will work

Regards

Posted on Apr 02, 2008

  • Ginko
    Ginko Apr 02, 2008

    when you select currency in format cells check also the setting for negative numbers, see that is format -$000 and not the notation in red.

  • reroute1991 Oct 23, 2012

    how about =A1 * -1????

×

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 119 Answers

As far as I know you don't even need a formula, just type a "-" symbol before the number

if this doesn't answer your question, please explain what you're exactly trying to do

Posted on Apr 02, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

Sometimes when I use a formula in Excel 2003 it will not calculate - it is as if the formula does not exist. an additional problem is that when the formula works it will not calculate several columns if...


Make sure, when you entr a formula that you hit the ENTER key instead of just moving to tyour next cell. To have all numbers added or moved, use the"Special" application, or change the value. Such as -if you are working in text mode and you enter numbers, they are only numbers in text mode. They don't have a value. Correct the cells to reflect numbers. Right click, format cell - select what you want.

Nov 05, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Sum of the greatest run of negitive numbers


Hi, Not sure if this is what you have tried:
1: Assuming each run is on a different column
Run1 Run2 Run3 Run4, etc...and the maxium lenght of each column is 9 values, but each colum has a different lenght of numbers..
Then you can use:
=MAX(COUNTIF(A2:A10,"<>0"),COUNTIF(B2:B10,"<>0"), {keep adding countif for each colum).

If all runs are on the same colum, then using Pivot tables is easier. If you have a copy of your data, please post it so that I can give you the exact formula ;)

Oct 21, 2009 | Microsoft Excel for PC

3 Answers

How do i insert a formula in a column to add each number & give a total at the bottom?


For example, you have three numbers from A1 to A3. On row A4, type =SUM(A1:A3).

That should do it. :)

Sep 16, 2009 | Microsoft Office Excel 2007

1 Answer

CAN GET COLUMNS TO ADD UP AND GIVE TOTAL ONLY GET SUBTOTALS


Use the function =sum() to add numbers. To sum, for example, all of column A, enter in the formula bar =sum($A:$A). You can use the subtotal function within the range you are adding and the answer will not count towards the final total.

Mar 14, 2009 | Microsoft Excel for PC

2 Answers

Excel will not displaying the results of a trend array formula


Hi Griffnz,

Your "known Y's" or 'values' are in Column B. This is the first array in the Trend formula.

Your "known X's" or 'months' are in Column A. This is the second array in the trend formula.

The trend formula is supposed to give you a projection of what the rest of the values in Column B will be over the next few months (usually continuing cells in Column A). The cells you want these values to show up in represent the third array in the formula.

Thus, your formula should look more like: '=trend(B3:B14,A3:A14,A15:A18)'

However, your formula is leaving out The values in B and adding values from C - -- but there ARE no values in C. Apparently, C is where you want the values to appear. In that case, the C array would be the third array in your formula. This would look more like '=trend(B3:B14,A3:A14,C3:C14)

If this doesn't make sense, let me know.

Sep 30, 2008 | Microsoft Excel for PC

1 Answer

BASIC EXCEL FORMULA


Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

columns: A B C D
rows
1 20 3
2 10 4
3 15 2
4 1 2 3


Then suppose you type in the following formulas (in the D column):

columns: A B C D
rows
1 20 3 =A1+B1
2 10 4 =A2-B2
3 15 2 =A3*B2
4 1 2 3 =sum(A4:C4)


Then the following answers will appear in the D column:

columns: A B C D
rows
1 20 3 23
2 10 4 6
3 15 2 30
4 1 2 3 6

Sep 29, 2008 | Microsoft Business & Productivity Software

3 Answers

More than 256 characters in a cell in Excel


If a RANGES
\r\n
Named Ranges. SheetLevel Named Range, Named Constants, Named Formulas ,Relative Named Ranges ,Dynamic Named Ranges ,Advanced Dynamic Named Ranges .
\r\nWorking With Ranges. FindLast cell/row/column etc.
\r\nFormula Reference Changer. Absolute to Relative etc.
\r\nSpecialCells Method
\r\nExcel Named Range Manager $
\r\nOFFSET RANGES VBA
\r\nReturns a Range object that represents a range that?s offset from the specified range. Read-only.
\r\nexpression.Offset(RowOffset, ColumnOffset)
\r\n\\"expression\\" is required and should be a Range object.
\r\n
\r\nRowOffset: Optional Variant. The number of rows (positive, negative, or 0 (zero)) by which the range is to be offset. Positive values are offset downward, and negative values are offset upward. The default value is 0.
\r\n
\r\nColumnOffset: Optional Variant. The number of columns (positive, negative, or 0 (zero)) by which the range is to be offset. Positive values are offset to the right, and negative values are offset to the left. The default value is 0.
\r\n
\r\nExample
\r\nSub OffsetMe()
\r\n MsgBox Range(\\"B2\\").Offset(RowOffset:=-1, ColumnOffset:=2).Address
\r\nEnd Sub
\r\nIs the SAME as;
\r\nSub OffsetMe()
\r\n MsgBox Range(\\"B2\\").Offset(-1,2).Address
\r\nEnd Sub
\r\nOFFSET FORMULA
\r\nReturns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference that is returned can be a single cell or a range of cells. You can specify the number of rows and the number of columns to be returned.Syntax = OFFSET(reference,rows,cols,height,width)
\r\n
\r\nExamples
\r\n=OFFSET(C3,2,3,1,1) Displays the value in cell F5.
\r\n=OFFSET(C3:E5,0,-3,3,3) Returns an error, because the reference is not valid.\", \"style=\\"background: #FFFFFF;padding: 2px;font-size: 10px;width: 550px;\\"\");" style="FONT-STYLE: italic" onmouseout="GAL_hidepopup();" href="http://www.ozgrid.com/forum/autolink.php?id=5&script=showthread&forumid=8">cell is formatted as Text, then it will display the #### when the text is over the limit. Reformat the cell to General and the text should again show.

Right click on the cell, click Format Cells, under the number tab, choose General.

Also, this ####, will occur is the cell width is to small.

May 16, 2008 | Microsoft Excel for PC

1 Answer

Excel Formula


Yes you can and there are two choices. The simple solution is to label a cell "divide by" and put your number in that filed. Then, by changing only that, your answer (in a separate cell) will be available.
There are more complex solutions -assuming your divide by number had some rhyme and reason that could be put in place but.....try this first and at a later date go back and play. Learning to do that will give you more than a fair amount of Excel expertise....something you may find fairly valuable as you continue on using Excel. FYI...I have developed full blown applications on Excel....it is an excellent tool. Hope this helps....Tango.

Feb 05, 2008 | Microsoft Excel for PC

1 Answer

Excel Formula


Do you simply need to have the formula: = I2 - F2

Is there a condition that you want to return zero?

Jan 19, 2008 | Business & Productivity Software

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

697 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18299 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...