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=472924