Need help with a formula

[Nobody]

I currently have a formula or function which is =SUM(B26-B17) what do I
add if I want the total to appear in red if it is a minus rather that a
positive

Thanks

 

[T. Valko]

You don't need the SUM function. Try it like this:

=B26-B17

To format a negative result as red:
Select the cell with the formula
Goto the menu Format>Cells>Number tab
Select one of the negative formats available
Set the decimal places to whatever you want
OK out

 

[JMiller]

Hello,

Please follow the steps bellow:
1- Right click on the cell where you have placed the formula;
2- A vertical menu will appear, then click where says "Format Cells"
3- When Excel displays the Format cell dialog box, click number tab and then
select the category you want to use(number or currency)
4- Select the 1234.10 if you choose number or select $1,234.10; if you
choose currency.

I hope it helped.
Regards,

JMiller

 

[Nobody]

No sure I worded my question corectly, I'll try again.
Lets say the cell I have that tells me the balance of 2 other cells,
currently it gives me a dollar amount and it is correct, it adds 2 cells and
then subtracts from another cell and the total appears in the cell I am
trying to make red if the total is a -

I tried the format cells and selected the red numbers but when I make the
total a - it's still black.

 

[Nobody]

I figured it out........thanks

No sure I worded my question corectly, I'll try again.
Lets say the cell I have that tells me the balance of 2 other cells,
currently it gives me a dollar amount and it is correct, it adds 2 cells
and then subtracts from another cell and the total appears in the cell I
am trying to make red if the total is a -

I tried the format cells and selected the red numbers but when I make the
total a - it's still black.

 

[JMiller]

Hello Nobody,

If you like, you can send the excel file to my email and I can try to do it
here.
Find bellow my email:
(e-mail address removed)