converting negative figure posit

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Converting a negative figure to a positive | Excel forum

Converting a negative figure to a positive | Excel forum

resolvedResolved · High Priority · Version 2007

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

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


 

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


Server loaded in 0.09 secs.