EXCEL formula problem… please help…?

im seeking to make the formula…i’d like to see the denominator within the formula that they are D9…but instead while i drag the idea down..the following happens:

c9/d9
c10/d10
c11/d11

i’d like to see the denominator for being all d9…i realize there’s your function with the..thanks!

You need to make it an absolute reference to be able to d9 as a result:

$d$9

Hello Rafael,

Shadow has the right answer for yourself.Just thought I might extend on it.

=c9/$d$9 Subsequently copy which down, the cel research $d$9 is known as an total reference, where c9 is really a relative research.When copied down, an individual formula would appears since follows:

=c10/$d$9
=c11/$d$9
=c12/$d$9

Whenever coped across your formula would seem as is a follower of:

=c9/$d$9 =d9/$d$9 =e9/$d$9

Wish this helps,
ve had.tcom

..reformat these as “General”, click the
system bar, and press..