Converting a negative number to a positive number

G

Guest

Hello,
I am working in Excel 2003. The first page of my workbook is a cover sheet
and contains the heading and total of each subsequent page. The user copies
and pastes the information to the worksheet. I have a formula set up whereas
the credits and debits are added together and provide a seperate total on
each page. e.g. =SUM(C2:C9999) On the cover sheet I have a formula set up
that enters the total beside the respective heading. e.g. =('Received
Today'!G1) So far, all is well. However, one of my worksheets has a debit
total (negative number) but needs to be entered onto the cover sheet as a
credit total (positive number). Could someone please tell me if I am able to
do this? If so, how? Any help is greatly appreciated!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top