I am doing some budgeting and came up with an excel quandry i cannot research the answer to. I have a series of numbers in a column, say a series of daily rates and each needs to be multipled by a number to the right.

and each row references back to the original number to its left. so in order to get the multiplication to work i could fill down to repeat the multiplication formula for each row.

here's the catch, i now want to fill the same formula across as well into new columns, also referencing back to that same daily rate number e.g. into new months. usuaully this would be done by using the $C$5 to keep the variables static. but by doing this it would prevent me from doing the original fill down operation.

anyways i ended up doing it manually cos it was like 15 rows but it got me thinking, if it was 500 rows. is there a way for the $ feature to relax its characteristic in relation to certain fill-down operations, so that i can fill-down a cell with a $ variable?

maybe

&

My cat's breath smells like cat food.

This is a helpful post.

$C5

Only keeps the column static so drag down and across still works.

Is that what you mean?

by not placing $ in front of the 5 when filling down the reference cell will move too.

I have NFI what you want to do, ermm it is almost 5 on the last friday of the though, so my brain might not be working so well (Does it ever?!)

voted 5

OK, I'm not really getting what you mean then.

But there's plenty of ways to do things.

worst problem description ever.

use a vlookup in your second calc?

You aren't very good at explaining yourself.
But since the post seems vaguely about cell referencing

Firstly there are 2 forms of cell referencing available to you in excel.
A1 and RC, You are probably using A1 since its default.

A1 (relative even tho it has a letter and number it really is relative to the current cell.)
The 3 below - $ means absolute
$A1 (no matter where you paste or fill this too it will always reference column A, but the row will be relative)
A$1 (this time it always refers to row 1, and the column is relative)
$A$1 (no matter where you paste this it will be A1)

You may also be looking for an array forumla. Which are uber handy. See this dummies page for more

yeah I needed to use A$1 because I was filling across but needed to reference back to a static column.

I guess it was a Friday arvo thing. Case closed.

obes wins

f*** excel and its formating and 65536 line limit

wtf?

is it still the early 90s?

i would like it to still be early 90's, bad haircuts, cheap fuel and duke3d

Not to forget Nirvana.

...and Lotus 1-2-3.

f*** excel and its formating and 65536 line limit

wtf?

is it still the early 90s?

f*** morons who think excel is a database program.

i agree

I also agree.

Seriously I do.

wow....

select the reference you're using i.e. e2 and press f4 on it a bunch of times, it cycles through the different locking options i.e. column lock, row lock or cell lock.

I thought everyone know about that.

i know you're all pro and s*** but no need to rub it in.