|
Formula to freeze a cell
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 |
Formula to freeze a cell
$B$1
-- Regards, Tom Ogilvy "mbasi" wrote in message ... 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 |
Formula to freeze a cell
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" wrote in message ... 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 |
Formula to freeze a cell
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 |
Formula to freeze a cell
Thanks guys, It worked :) I need to brush up on my excel skills. Mani :) -- mbasi ------------------------------------------------------------------------ mbasi's Profile: http://www.excelforum.com/member.php...o&userid=27780 View this thread: http://www.excelforum.com/showthread...hreadid=472949 |
| All times are GMT +1. The time now is 04:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com