[techtalk] Tech-Talk: EXCEL - Reverse Negative Numbers for Calculating

Tue Jul 18 14:04:22 PDT 2017

Greetings!

The Tech-Talk e-newsletter for Oregon library workers is distributed weekly via the Libs-OR and TechTalk mailing lists. Please do not forward.

Know someone who might be interested in receiving a copy but they’re not on the Libs-OR or TechTalk mailing lists? Have them contact darci.hanning at state.or.us<mailto:darci.hanning at state.or.us> or visit http://listsmart.osl.state.or.us/mailman/listinfo/techtalk to receive the TechTalk newsletter!

This paid subscription service is supported in whole by the Institute of Museum and Library Services (IMLS) through the Library Services and Technology Act (LSTA), administered by the State Library of Oregon. Enjoy!

[http://www.tech-talk.com/wp-content/uploads/2016/11/Tech-Talk-logo-300.png]

Brought to you by the State Library of Oregon

[State of Oregon]

The State Library is pleased to provide you with Tech-Talk.com. We encourage you to make the most of this skill-building membership site at www.Tech-Talk.com<http://r20.rs6.net/tn.jsp?f=001zTY8jVn6AZgHyac5H4CYuOhIEsQhNifMjDxVs-quodSGZ1G8HQ-MlC5azn-1CVJVYaPBP2nDObMu-5JXcwRv0ynSwe8jNdTM3qBKT0g9eNqxWuQ5r9BikLi7MF3GWrMyXsEOzXPwowKiDkb8cXXw6w==&c=hLHPY72RoE6-_ILPrlHig51HNYAhZZbw18q8Kyjq17Em4ZeH6WU6nw==&ch=xB3mFag5wsjlwCWUShX8YHZv0e-z18l76yS6mjtEgnpwIVPtbgL5-w==>.

Username: ORLIBTECH
Password: ORLIBTECH  (case sensitive)

Contact Darci Hanning at darci.hanning at state.or.us<mailto:darci.hanning at state.or.us> if you have questions.

[http://www.tech-talk.com/wp-content/uploads/2016/09/video-image.png]<http://r20.rs6.net/tn.jsp?f=001zTY8jVn6AZgHyac5H4CYuOhIEsQhNifMjDxVs-quodSGZ1G8HQ-MlFyTfBzX-gS7Ha3XBq0y1pXl2o__fTCqwi7CNBGTg5FFNLs1lqlIKrYXEAwmcmK8s2sD6LMcGKZ8Px61GFk5egI95uNnRsqgPxjFD-86PVvIWaruHWjXGqaS7KjtE9AIQKG51IVf7OCz&c=hLHPY72RoE6-_ILPrlHig51HNYAhZZbw18q8Kyjq17Em4ZeH6WU6nw==&ch=xB3mFag5wsjlwCWUShX8YHZv0e-z18l76yS6mjtEgnpwIVPtbgL5-w==>

 This Week's Tech-Talk:  EXCEL

1. VIDEO ... Reverse Negative Numbers
2. ARTICLE ... Reverse Negative Numbers
3. COMMUNICATING ... "Fair and Reasonable"

NOTE: To view the VIDEO, click here<http://r20.rs6.net/tn.jsp?f=001zTY8jVn6AZgHyac5H4CYuOhIEsQhNifMjDxVs-quodSGZ1G8HQ-MlFyTfBzX-gS7Ha3XBq0y1pXl2o__fTCqwi7CNBGTg5FFNLs1lqlIKrYXEAwmcmK8s2sD6LMcGKZ8Px61GFk5egI95uNnRsqgPxjFD-86PVvIWaruHWjXGqaS7KjtE9AIQKG51IVf7OCz&c=hLHPY72RoE6-_ILPrlHig51HNYAhZZbw18q8Kyjq17Em4ZeH6WU6nw==&ch=xB3mFag5wsjlwCWUShX8YHZv0e-z18l76yS6mjtEgnpwIVPtbgL5-w==>. Enter the User Name and Password!

Tech-Talk: EXCEL  - Reverse Negative Numbers

Have you ever been working in a spreadsheet with numbers in a column (or a row) that were mixed with both negative and positive numbers ... causing a problem?  You want to add them, but the negatives are canceling out the positives, giving you the wrong answer!

For example, you're working in an Excel spreadsheet with downloaded expenses and income data for the month.  Most of the costs appear as negative ($ -6.50), but you want to add them.

You don't want negatives, you want "absolute values".  You want numbers to be positive – so that you can add them up to identify the total spent on expenses.

[Reverse negative numbers]

There is a simple way to eliminate all the negative (-) signs by converting these numbers into their absolute value ... using the ABS formula. When you use this built-in formula, the ABS function returns the absolute value of an integer. Negative numbers are converted to positive, and positive numbers are not affected.

Convert Negative Numbers to Positives with the ABS Function

To convert negative numbers, do these few steps using Paste Special:

[paste special]

  *   Somewhere in your Excel spreadsheet, type -1 in a cell.  You can delete it later.
  *   Highlight that cell, right-click and choose Copy.
  *   Select/highlight the negative numbers you want to convert to positive.  (Hold the Ctrl key each time you click if you are selecting more than one.)
  *   Move your cursor to one of the highlighted cells, and right-click. Choose Paste Special, then Paste Special in the second drop-down.
  *   In the window, in the Paste section, select Values.
  *   In the Operation section, choose Multiply.
  *   Then OK.

[ABS function]

Now your negative numbers will show the absolute value (positive) for that cell.

[http://files.constantcontact.com/ee1208b4001/f8f1ecc8-4884-4c21-8ed0-cf647e6db944.png]

Communicate - Talking / Writing
"Fair and Reasonable"

I love the words, "fair and reasonable"!

They go together so well. They pack a powerful punch for gaining agreement on something specific such as a project deadline, a budget amount or an approach.

  *   "Is the end of next week a fair and reasonable deadline?"
  *   "Does $1,500 sound like a fair and reasonable budget?"
  *   "Would talking to students first be a fair and reasonable approach?"

A Great Twist

You can also gain insight to unspoken assumptions by asking this as an open-ended question of someone,

  *   "What would be a fair and reasonable date to have this finished?"
  *   "What would you consider as a fair and reasonable budget amount?"
  *   "What do you think would be a fair and reasonable approach to this project?"

Typically, you'll find others tell you exactly what they are thinking when you use these two words so that you can come to an understanding quickly and agreeably.

[http://www.tech-talk.com/wp-content/uploads/2017/04/3-kids-innovative.png]

 CLICK HERE ... FOR THE TECH-TALK LIBRARY!<http://r20.rs6.net/tn.jsp?f=001zTY8jVn6AZgHyac5H4CYuOhIEsQhNifMjDxVs-quodSGZ1G8HQ-MlC5azn-1CVJVYaPBP2nDObMu-5JXcwRv0ynSwe8jNdTM3qBKT0g9eNqxWuQ5r9BikLi7MF3GWrMyXsEOzXPwowKiDkb8cXXw6w==&c=hLHPY72RoE6-_ILPrlHig51HNYAhZZbw18q8Kyjq17Em4ZeH6WU6nw==&ch=xB3mFag5wsjlwCWUShX8YHZv0e-z18l76yS6mjtEgnpwIVPtbgL5-w==>
Your Membership Site!

NOTE: Forgot your user ID?  See your sponsor block at the top. Problems? Contact us at Support at Tech-Talk.com<mailto:Support at Tech-Talk.com>

 Do You Have A Suggestion For An Article, or a
"Using Technology" Problem?

We can help!
Just tell us here and we'll get you the answer!<http://r20.rs6.net/tn.jsp?f=001zTY8jVn6AZgHyac5H4CYuOhIEsQhNifMjDxVs-quodSGZ1G8HQ-MlCgUbwaHpEZb07ykkTbt2jKpdi5ElJXvdm75_Qew64XXrorcoRa8omFD5ZhDigFC6RLt3tlP5JjGWiOW_G-lJOiJEKwGA4z3obq4SSSC1iLwBiDFmgrL8zk=&c=hLHPY72RoE6-_ILPrlHig51HNYAhZZbw18q8Kyjq17Em4ZeH6WU6nw==&ch=xB3mFag5wsjlwCWUShX8YHZv0e-z18l76yS6mjtEgnpwIVPtbgL5-w==>

Copyright 1996-2017 Shared Results International. Published weekly. Do not forward this issue of Tech-Talk.com without prior permission from Shared Results International. Distribution is limited by contract. Forwarding it to unauthorized recipients constitutes copyright infringement. For information on site licenses or how to include additional recipients, email darci.hanning at state.or.us<mailto:darci.hanning at state.or.us>.

Cheers!

Darci Hanning, MLIS
Technology Development Consultant
darci.hanning at state.or.us<mailto:darci.hanning at state.or.us> | 503-378-2527 | www.oregon.gov/osl/ld<http://www.oregon.gov/osl/ld>
Follow us: Facebook<http://fb.me/orlibsupport> | Twitter<https://twitter.com/ORLibSupport> | Tumblr<http://www.statelibraryor.tumblr.com/> | Pinterest<https://pinterest.com/statelibraryor/>
Ask me about the Edge Initiative<http://oregonedge.net/>!

[cid:image003.png at 01D2FFCE.C0F95FC0]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/techtalk/attachments/20170718/b8b81d00/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 15558 bytes
Desc: image003.png
URL: <https://omls.oregon.gov/pipermail/techtalk/attachments/20170718/b8b81d00/attachment.png>