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

converting negative figure posit

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

Converting a negative figure to a positive

ResolvedVersion 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:

Toggle Formulas and Results

Ctrl + 'The key above Tab with the

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.