Formula to freeze a cell

[mbasi]

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 :|

 

[Tom Ogilvy]

$B$1

 

[Paul B]

mbasi, use |=B4*2.7/100*105*82/100*B$1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[jashby2]

Hi,

I think what you are referring to is absolute vs. relative referencing.
I think if you just put dollar signs with the cell reference it shall
stay B1 throughout.

e.g. your formula .....*105*82/100*$B$1

Check this out for a better explanation:
http://www.techonthenet.com/excel/questions/referencing.php


good luck,
jashby2

 

[mbasi]

Thanks guys,

It worked I need to brush up on my excel skills.

Mani