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