Jump to content


Convert negative numbers to positive in Excel

formulas IF

  • Please log in to reply
1 reply to this topic

#1 BMan



  • Members
  • Pip
  • 6 posts

Posted 26 November 2013 - 03:18 PM



I have a spreadhseet that has positive and negative numbers for invoices and credits.


I want to convert the values of the credits to positive numbers without making the invoices negative (so can't multiply by -1).


Thanks in advance for your help! :)


Attached File  credits.xlsx   8.37KB   70 downloads


#2 Jonathan


    Forums Administrator

  • Administrators
  • 376 posts

Posted 26 November 2013 - 03:22 PM

You can create a formula that will do this by using an IF function to check whether the value is negative and then multiplying the value by -1 if it is.


Your IF formula will look something like:



If you're having trouble understanding this formula, you can find more explanation of the IF function in Expert Skills Lesson 3-5: Use the IF logic function.


I have attached a copy of your spreadsheet with the formula applied.


Attached File  credits.xlsx   9.04KB   65 downloads



I hope this is helpful.  Feel free to reply if you need any more assistance.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users