Thread: Excel Pro wanted
View Single Post
Old 20-04-2004, 13:36   #2
SMHarman
Inactive
 
Join Date: Jun 2003
Services: Cablevision
Posts: 8,305
SMHarman is cast in bronzeSMHarman is cast in bronzeSMHarman is cast in bronzeSMHarman is cast in bronze
SMHarman is cast in bronzeSMHarman is cast in bronzeSMHarman is cast in bronzeSMHarman is cast in bronzeSMHarman is cast in bronzeSMHarman is cast in bronzeSMHarman is cast in bronzeSMHarman is cast in bronzeSMHarman is cast in bronzeSMHarman is cast in bronzeSMHarman is cast in bronzeSMHarman is cast in bronzeSMHarman is cast in bronzeSMHarman is cast in bronzeSMHarman is cast in bronzeSMHarman is cast in bronzeSMHarman is cast in bronzeSMHarman is cast in bronzeSMHarman is cast in bronze
Re: Excel Pro wanted
Something like below.

In Sheet2 put this equation in the bit before the ! defines an alternate sheet. This example will increase sheet 1 A1 by 5%.

=+Sheet1!A1*0.05

Best practice would be to put the increase percentacge in a separate cell and refer to that

=+Sheet1!A1*Sheet2!A20

where A20 is the percentage increase

=+Sheet1!A1*Sheet2!$A$20

Putting $ on the A and the 20 will ensure that when the equation is copied the A20 stays the same. You can do this with the cursor on the cell reference and pressing F4, or type it.
SMHarman is offline   Reply With Quote