45 votes10 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →Dennis M Wallentin commented
Instead of entering 10 % You should of course enter 1.1!Dennis M Wallentin commented
Like many other users, You have not yet discovered this feature.
Assume You've have a budget that need to be increased with 10 %. The easiest way is to:
- Enter 10 % in an empty cell
- Paste Special operation, in this case Multiplying.
Instead of using a cell in the worksheet a numeric field as per screen shot will make it smoother. Give it a try and You will soon find out its value :-)Dennis M Wallentin shared this idea ·