Converting a negative figure to a positive | Excel forum

Resolved · High Priority · Version 2007

Tue 13 Oct 2009, 12:29 Delegate Jason said...

Jason has attended:
Excel Advanced course

Converting a negative figure to a positive

I am currently working on a spreadsheet were i am using the formula =Sum( and clicking on various cells in another folder.
The total comes back as a negative figure which is correct but i want the figure to be shown as a positive and recongnised as a positive as it adds into a total . hope you can help.

Many Thanks Jason

Tue 13 Oct 2009, 13:42 Trainer Amanda said...

RE: Converting a negative figure to a positive

Hello Jason

Thank you for your question and welcome to the forum.

I think all you need to do is put a minus sign between the = and the SUM, i.e. =-SUM(

This should convert the negative result to a positive one.

Kind regards
Amanda

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips