Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default How do I increase a spread sheet by 10%

I Am doing a spread sheet, I have completed it they are for four years - I
need to increase the last three years each by 10% - anyone know what I do or
the formular?
Thanks
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default How do I increase a spread sheet by 10%

Joni

Enter 1.1 in an unused cell.

Copy that cell.

Select your range of numbers for the three years and EditPaste Special(in
place)MultiplyOKEsc.

Clear the cell with 1.1


Gord Dibben MS Excel MVP

On Wed, 21 Feb 2007 14:29:05 -0800, Joni wrote:

I Am doing a spread sheet, I have completed it they are for four years - I
need to increase the last three years each by 10% - anyone know what I do or
the formular?
Thanks


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i enter a bull call spread into the options spread sheet ? alvin smith Excel Worksheet Functions 0 November 27th 06 01:23 AM
spread sheet equality 547 New Users to Excel 2 May 5th 06 03:51 PM
spread sheet equality 547 Charts and Charting in Excel 1 May 2nd 06 11:10 AM
spread sheet equality 547 Charts and Charting in Excel 0 May 2nd 06 02:02 AM
spread sheet crix411 Excel Worksheet Functions 2 April 9th 05 03:42 PM


All times are GMT +1. The time now is 06:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"