Hi

I'm not sure how your message got into this thread, but the answer to
your problem is to use $ to fix the cell location
$B$1

The first $ makes the column fixed, the second $ makes the row fixed.

Regards

Roger Govier



mbasi wrote:

Hey everyone,

I am doing some calculations on excel and I'm trying to make my life
more simple.

For example, I'm trying to do the followowing:

A | B | C
|
_________________________________________________ ___
1|Percentage Increase:|10 |
|
2|
3|Desc: |Price | After Increase
|
4|Base 300 |10.50 |=B4*2.7/100*105*82/100*B1 |
5|Wall 300 | 8.50 |=B5*2.7/100*105*82/100*B1
|
6|Base 600 | 20.00|=B6*2.7/100*105*82/100*B1 |

Basically my queston is, how do I enter the B1 and make sure it stays
as B1. When I enter the formula in the first cell (C4) and then drag to
the end of the column, the section in the formula where it shows *B1
changes to whatever row I am in.

For example:

A | B | C
|
_________________________________________________ ___
1|Percentage Increase:|10 |
|
2|
3|Desc: |Price | After Increase
|
4|Base 300 |10.50 |=B4*2.7/100*105*82/100*B1 |
5|Wall 300 | 8.50 |=B5*2.7/100*105*82/100*B2
|
6|Base 600 | 20.00|=B6*2.7/100*105*82/100*B3 |

I want the B1 section to be frozen and remain as it is throughout the
formula.

I hope this makes sense.

Many thanks

Mani :|