Categories

Our Sponsor

Enter discount code WRITER111 in the shopping
cart and save $50 at ...

Users Online

+ 35 Guests + 4 Bots

Unique Visitors

  • 153885Visitors Total:
  • 876Visitors TODAY:
  • 1688Visitors Yesterday:
  • 10708Visitors Last Week:
  • February 15, 2013Since:

Member



How to Line Up Numbers on Decimal Points in Excel

Tweet

© Ugur Akinci

Did you have a column of numbers in MS Excel that looked ugly like this:

You can have a really nice looking column of numbers by centering them on the DECIMAL POINT — even if some of them do not have a decimal point.

The [...]

Share

How to Extract Text or Numbers from Character Delimited Cell Content in MS Excel

Tweet

© Ugur Akinci

Character-delimited data is fairly common. Here is an example:

100&4657&23&495&103

or

Apple$Pear$Orange$Cherry$Grapes

Imagine having a MS Excel table with cells populated with such content. How would you separate the text or the numeric values and post them under their own separate columns?

Here is an example [...]

Share

How to Calculate Quantity Discount Price for Bulk Purchases with MS Excel NESTED IF Function

Tweet

© Ugur Akinci

To reward the customer with quantity discounts for bulk purchases is a common practice in business.

Consider the below situation:

There are FOUR different IF statements here illustrated by the above table:

(1) Here the seller is charging $10 per item if the customer purchases [...]

Share