answersLogoWhite

0


Best Answer

=-b7

where b7 is an example cell reference. The result will be the negative of whatever is in b7.

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Is there any shortcut function to match positive amount with Negative amount in Excel 2007?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the difference between negative sine and cosine graphs and positive sine and cosine graphs?

The negative sine graph and the positive sine graph have opposite signs: when one is negative, the other is positive - by exactly the same amount. The sine function is said to be an odd function. The two graphs for cosine are the same. The cosine function is said to be even.


What happens when you add negative to positive?

Adding a negative amount is equivalent to subtracting a positive amount.


If you divide a negative number by a negative number will you get a positive number?

You will end up with a positive number. With integers, if you multiply or divide an even amount of negative numbers, the answer will be positive and if you multiply or divide an odd amount, the answer will be negative.


Will the product of 101 negative integers be positive or negative?

If the amount of negative integers being multiplied is even, the result will be positive. If it is odd (like 101), the product will be negative.


Does holly tree have positive or negative impact And why?

positive, it increases the amount of oxygen in the air.


What if you add a large positive number with a small negative number - Which sign will the answer have ... Positive or Negative?

If you have MORE positive amounts, than you have negative amounts, then the balance is a POSITIVE result. So answer is POSITIVE. Think of it like this:- -6+9 is the same thing as +9-6, and, 9minus 6 = 3 but we only bother with the 'sign' if the amount is a negative amount, so 3 always means +3


When adding integers and ones negative how do you figure out the answer?

Take the positive one and subtract the negative amount.


How does the amount of positive charge on a proton compare with the amount of negative charge on a electron?

equal but opposite


Matter that has an equal amount of positive and negative charge are known as?

Neutral


Where there is an equal amount of positive and negative charges on an object the object is?

Electrically neutral


How are negative numbers represented across mathematical disciplines?

Infinite. There are an infinite amount of positive numbers as well as negative numbers.


Is 0 is the smallest even number?

No. You an get an infinite amount of minus numbers, and any of those which are positive when they are even will be positive when they are negative.