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

--
Regards,
Tom Ogilvy

"mbasi" <[email protected]> wrote in
message news:[email protected]...
>
> 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 :|
>
>
> --
> mbasi
> ------------------------------------------------------------------------
> mbasi's Profile:
http://www.excelforum.com/member.php...o&userid=27780
> View this thread: http://www.excelforum.com/showthread...hreadid=472949
>

[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

"mbasi" <[email protected]> wrote in
message news:[email protected]...
>
> 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 :|
>
>
> --
> mbasi
> ------------------------------------------------------------------------
> mbasi's Profile:
> http://www.excelforum.com/member.php...o&userid=27780
> View this thread: http://www.excelforum.com/showthread...hreadid=472949
>

[[email protected]]

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/qu...eferencing.php


good luck,
jashby2

[mbasi]

Thanks guys,

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

Mani