Negative amount in cell

  • Thread starter Thread starter acceber
  • Start date Start date
A

acceber

Is there a way to make a cell a negative amount without having to pu
the "-" negative sign in the cell? Or is there a way to make th
formula a positive instead of a negative amount
 
can't you just put parenthesis around the formula and put a negative?

=2+2 gives 4
= -(2+2) gives -4

Maybe your going for somethingmore complicated here..
 
The formula that I am using is =SUM(F34/84*L34-F34) and when I put
negative sign in front of the parenthesis I get this #NAME? in th
cell. Of course if I put a negative amount in the F34 cell then th
total will come out correctly but I was hoping to get around doin
that
 
Put the negative sign in front of the word SUM, otherwise Excel think
you are going to substract something from a SUM, but you haven'
indicated what the SUM would be...

Just to make sure I'm being clear:
=-SUM(B2:B6)

m
 
The formula that you posted doesn't actually need the SUM
around it. If you want to do F34/84 and L34-F34 and then
multiply the two together you need the following formula:

=(F24/84)*(L34-F34)
You can put a minus sign in front if you like to get a
negative value.

I hope this is what you meant!

Judith
 
Back
Top