How do you make a cell in Excel always display the value as negative? Regardless of what number is entered?

Answer 1

You can use the absolute function within Excel and multiple that by -1 ... absolute of the cell value will always be positive and then by multiplying it with -1 makes it negative.

=ABS()*-1

Answer 2

Use conditional formatting. For example if you enter the number 4 and want it to show as -4 use a formula such as this:

1st create another cell that equals the entry cell (where you type 4).
In other words, you enter 4 in cell c14.
Cell c15 equals this .
Next go to cell c14 and use conditional formating.
=if greater than 0, then = c15 -c15-c15

or 4-4=0 -4 =-4

Answer 3

you could use an if/then statement.
You are trying to tell it, look at this cell, if the value is greater than 0 (a positive number), then multiply its value by a negative one.

I have a mac so I cant look it up for you but it would be something like. =if c1 > 0, then c1*(-1)

Go to your excel help and type in If Then.

Answer 4

Select the cells which one u want the values to be displayed negative

in format menu select cell and in that number column u will find neagtive integers select the appropriate and click on ok

Good Luck and Happy Browsing.............

Answer 5

format
cells
number

It will not let you format as always negative....you need to make sure you have properly put in the formula...and if the person enters the reference cell value incorrectly it might still return it as a positive.

just read the guy before me....he's got it right.

Answer 6

Use the SIGN function to determine if a number is already negative. If not, multiple it by -1.

Answer 7

Insert an "IF" formula that multiplies any number that is greater than 0 by -1.

Answer 8

Select the cell where u want this functoinalilty. Select Data > Validation under the first tab "Settings" under "allow" drop down select, whole number or decimal and under "data" drop down select, less than and under "maximum" text box enter "0" now go to tab "error alert" and ensure the "style" drop down has stop with a red cross icon shown and select ok.