ExcelBanter - Formula constants?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula constants? (https://www.excelbanter.com/excel-worksheet-functions/200705-formula-constants.html)

Glenn L.[_2_]

Formula constants?

I want to use the following formula in cell B3:

=(A3*(C29+3))-B29

However, I want to drag this formula down column B, but keep "(C29+3))-B29"
constant. I only want "A3" to change to A4, A5, A6, etc. as I drag the
formula down to cell B25. How do I keep the "(C29+3))-B29" part of the
formula constant?

One of the problems that I'm having in solving this (using Excel HELP) is
that I do know the correct term for what I'm trying to do. I think the term
"constant" is not correct in this situation.

Any help would be greatly appreciated.

Dave Peterson

Formula constants?

You'd want to look at relative or absolute addressing:

=(A3*($C$29+3))-$B$29

Glenn L. wrote:

I want to use the following formula in cell B3:

=(A3*(C29+3))-B29

However, I want to drag this formula down column B, but keep "(C29+3))-B29"
constant. I only want "A3" to change to A4, A5, A6, etc. as I drag the
formula down to cell B25. How do I keep the "(C29+3))-B29" part of the
formula constant?

One of the problems that I'm having in solving this (using Excel HELP) is
that I do know the correct term for what I'm trying to do. I think the term
"constant" is not correct in this situation.

Any help would be greatly appreciated.

--

Dave Peterson

Glenn L.[_2_]

Formula constants?

Worked like a charm, Dave. Thanks for responding and helping me. Also,
thanks for giving me the proper terminology.

"Dave Peterson" wrote:

You'd want to look at relative or absolute addressing:

=(A3*($C$29+3))-$B$29

Glenn L. wrote:

I want to use the following formula in cell B3:

=(A3*(C29+3))-B29

However, I want to drag this formula down column B, but keep "(C29+3))-B29"
constant. I only want "A3" to change to A4, A5, A6, etc. as I drag the
formula down to cell B25. How do I keep the "(C29+3))-B29" part of the
formula constant?

One of the problems that I'm having in solving this (using Excel HELP) is
that I do know the correct term for what I'm trying to do. I think the term
"constant" is not correct in this situation.

Any help would be greatly appreciated.

--

Dave Peterson

All times are GMT +1. The time now is 07:18 AM.