Question about Microsoft Office Professional 2007 Full Version for PC

1 Answer

I am attempting to add a negative number in one cell with a positive number in another cell and the answer I get is a repeat of the positive number. what am I doing wrong.

Posted by on

  • A Soveral May 11, 2010

    I don't quite understand your problem. What is the formula you are using to get the sum? If you want to sum 2 numbers in different cells, you

×

Ad

1 Answer

  • 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
  • 566 Answers

I don't know if I quite undestood your problem, but, if you want to add values in 2 different cells (A1 and B1) and get the result in a 3rd cell (C1), you can either use the formula "=A1+B1" or the formula "=SUM(A1:B2)" in C1 (3rd cell).
Hope this helps.

Posted on Jul 21, 2009

  • A Soveral Jul 22, 2009

    Sorry, I mistyped the second formula. It should be "=SUM(A1:B1)"

×

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
New users get to try the service completely Free afterwhich it costs $6 per call and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

10 Answers

In Excel adding positive and negative numbers


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
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

Apr 02, 2008 | Computers & Internet

1 Answer

Why won't my calculator add or substract?


It looks like it may have adding machine logic.

Do this key sequence:

5 + 5+ 6-. Is the answer 4?

Each number you enter is positive or negative and it is just keeping a running total, rather than adding and subtracting numbers.

Let me know if this helps.

Good luck.

Paul

Jul 22, 2014 | Sharp EL-2630PIII Desk Calculator 12-Digit...

1 Answer

What to numbers can you multiply to get 280 and add to get-18?


When you say "to numbers" I assume you meant "two numbers."

There is no solution.

For the product of two numbers to be 280, either both numbers must be positive or both numbers must be negative. For the sum of two numbers to be -18, one or both numbers must be negative. Taken together, both numbers must be negative.

We can find two numbers that multiply to 280 and add to +18, then simply take the negative of both numbers.

The square root of 280 is about 16.7. The sum of any two numbers that multiply to 280 must be at least twice that, or at least 33.4. Since 33.4 is greater than 18, there is no solution.

If you want to do it the hard way, take any pair of negative numbers that multiply together to 280, add them together, and see how close you come to -18. For example, -1 and -280 add to -281. -2 and -140 add to -142. -4 and -70 add to -74. -5 and -56 add to -61. -7 and -40 add to -47. -8 and -35 add to -43. -10 and -28 add to -38. -14 and -20 add to -34, which is as close as you can come in the integers.

Jun 25, 2014 | Office Equipment & Supplies

2 Answers

I can't get rid of the zero in front of the minus, add, multiply and devide sign. how do i get rid of it?


Are you entering any number before pressing the minus, add, multiply, or divide key? Those operations require two numbers; if you don't supply the first one then the calculator will supply the previous answer, which was zero.

For example, to add 2 and 3, press 2 + 3 = and you'll see 5. Now to add 4 to that, press + and the calculator will automatically supply the 5. Press 4 = and you'll see 9.

Oct 08, 2013 | Sharp el-531x scientific calculator

1 Answer

How to add and subract


To add 3 and 5 on your calculator, start off by making
sure all is clear with no numbers showing in the display.
Push the 3 key, then push the + key, then push the
5 key, then push = . The answer should appear.
To subtract repeat the above process but push the
minus (-) key in place of the + key. If you subtract
5 from 3 you will get a negative (-) number 2.
Does this solve your problem? If not, ask your
question again but in a different way.

Aug 29, 2011 | Texas Instruments TI-5045 SVC Calculator

1 Answer

When I square a negative number (eg -2^2) it gives me a negative answer (-4) why isn't it giving me a positive answer?


You're not squaring a negative number, you're negating a square. What you need to do is calculate (-2)^2 instead of the -(2^2) you're now calculating.

Feb 04, 2010 | Texas Instruments TI-83 Plus Calculator

1 Answer

Tring to subtract


With an adding machine, which is what this is, you enter the number followed by the + or -. If you wanted to add 10+20, you would enter 10 then + then 20 then +. This would show your answer. If you are using the printer and you wish to see the final answer on the paper, hit the * key and your answer will print.

If you are subtracting, let's say 100-40, you would enter 100 then + then 40 then - then *. Adding machines expect you to enter long strings of numbers to total. You may have both positive and negative numbers. So, you always enter the number first followed by either positive + or negative -.

You might have 100 + 25 - 37 - 1 + 50. For that enter:
100+25+37-1-50+ then *

Different than a calculator but the same for all "adding machines". This machine should really be called an adding machine since that is the kind of input it is looking for.

Jan 13, 2009 | Canon P23-DHV Calculator

1 Answer

Negative answer when squaring a neg number


You must put all negative numbers in Parenthesis otherwise your calculator is not squaring the negative .

Apr 20, 2008 | Texas Instruments TI-85 Calculator

Not finding what you are looking for?
Microsoft Office Professional 2007 Full Version for PC Logo

Related Topics:

45 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2839 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18402 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...