Jump to content


Photo

Convert negative numbers to positive in Excel

formulas IF

  • Please log in to reply
1 reply to this topic

#1 BMan

BMan

    Newbie

  • Members
  • Pip
  • 6 posts

Posted 26 November 2013 - 03:18 PM

Hi,

 

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   25 downloads

credits2.png



#2 Jonathan

Jonathan

    Forums Administrator

  • Administrators
  • 222 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(B2<0,B2*-1,B2)

 

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   21 downloads

credits.png

 

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