Upload

Loading icon Loading...

This video is unavailable.

Mr Excel & excelisfun Excel Trick #2: Decrease Values By 35%

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to like ExcelIsFun's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to dislike ExcelIsFun's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to add ExcelIsFun's video to your playlist.

Uploaded on Mar 9, 2009

See Mr Excel and excelisfun demonstrate two methods to subtract 35% from a column of values:
Mr Excel: Create formula for remaining percentage (1 + decrease), copy remaining percentage, Paste Special, Operations Multiply, Values. Subtract 35% from a column of values.

excelisfun: Create formula for remaining percentage (1 + decrease), create new column with formula (Original Price * remaining percentage) to calculate column of values that subtract 35%.
MrExcel's Learn Excel #966 - Reduce by 35%
YouTubersLoveExcel#16: Percent Number Formatting Tricks

Loading icon Loading...

Loading icon Loading...

Loading icon Loading...

The interactive transcript could not be loaded.

Loading icon Loading...

Loading icon Loading...

Ratings have been disabled for this video.
Rating is available when the video has been rented.
This feature is not available right now. Please try again later.

Loading icon Loading...

Advertisement
Loading...
Working...
to add this to Watch Later

Add to