answersLogoWhite

0

What does the negative sign do in excel?

Updated: 8/20/2019
User Avatar

Wiki User

10y ago

Best Answer

The same as in many programming languages and other places where formulae are used. The negative sign can basically do one of the following:

As a unary symbol (i.e., before a number), convert a positive to a negative, or a negative to a positive. For example, if "x" is positive, "-x" is negative, and vice versa.

As a binary symbol (i.e., between two numbers), it means subtraction.

User Avatar

Wiki User

10y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What does the negative sign do in excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the arithmetic operator that makes a number negative in Excel?

The minus sign.


In Microsoft Excel cell How do you change the negative sign to positive?

Multiply by -1


What is the symbol for negation in excel?

The minus sign: - Negative values can also be indicated by showing them in red or having brackets around them.


What are three signs in Excel?

There are many signs used in Excel. Three of them are the plus sign (+), the minus sign (-) and the multiplication sign (*).


How do you remove negative sign of a number in a cell of Excel sheet?

It depends on how the negative sign got on the cell. If you typed it, then edit the cell and remove the negative sign. If it was calculated and you want to show only the number without a sign, you can do one of two things:Multiply the results times -1.Use the ABS function to return the absolute value of the number. =ABS(2-3) will return 1 instead of -1.


Does the negative sign come before or after the dollar sign?

Does the negative sign come before or after the dollar sign?The negative sign comes before the dollar sign.


Which are the positive and negative?

The ones with the + sign are positive. The ones with the - sign are negative.


What do you have to put in a cell to denote an equation in Excel?

In Excel an equation can be a formula. All formulas in Excel must start with the equals sign. That is what tells Excel it is a formula.


Why is there 2 minus signs at the start of a Trim Excel formula?

All functions in Excel start with the = sign. So you may be mistaking that for two minus signs. A minus sign will have no impact on an TRIM function as it is a text function.All functions in Excel start with the = sign. So you may be mistaking that for two minus signs. A minus sign will have no impact on an TRIM function as it is a text function.All functions in Excel start with the = sign. So you may be mistaking that for two minus signs. A minus sign will have no impact on an TRIM function as it is a text function.All functions in Excel start with the = sign. So you may be mistaking that for two minus signs. A minus sign will have no impact on an TRIM function as it is a text function.All functions in Excel start with the = sign. So you may be mistaking that for two minus signs. A minus sign will have no impact on an TRIM function as it is a text function.All functions in Excel start with the = sign. So you may be mistaking that for two minus signs. A minus sign will have no impact on an TRIM function as it is a text function.All functions in Excel start with the = sign. So you may be mistaking that for two minus signs. A minus sign will have no impact on an TRIM function as it is a text function.All functions in Excel start with the = sign. So you may be mistaking that for two minus signs. A minus sign will have no impact on an TRIM function as it is a text function.All functions in Excel start with the = sign. So you may be mistaking that for two minus signs. A minus sign will have no impact on an TRIM function as it is a text function.All functions in Excel start with the = sign. So you may be mistaking that for two minus signs. A minus sign will have no impact on an TRIM function as it is a text function.All functions in Excel start with the = sign. So you may be mistaking that for two minus signs. A minus sign will have no impact on an TRIM function as it is a text function.


When you click the function button in Excel what sign does it automatically put in the cell?

The equals sign.


Where can I sign up for excel training online?

Here's a great site to sign up for online excel training: office.microsoft.com/en-us/training/cr061831141033.aspx


What does the negative terminal of a battery have?

The negative terminal of a battery has a - sign and positive terminal has a + sign.