Daily tips for using Microsoft Excel.

Wednesday, January 30, 2002

Daniel ask "Im just trying to find out how I can add 50% to each number in a selected range of numbers. I need each number to have 50% added/ x 1.5."

This one is easy. In an empty cell put 1.5 or 150%, copy it (Control C), then, select the range of numbers you want to increase, go to Edit, Paste Special, Values (or formulas, up to you), and also choose Multiply. Click [OK] and DONE !

That easy !