problem writing this (1/(1+0.38))^2

  • Thread starter Thread starter Murdock85
  • Start date Start date
M

Murdock85

hello everybody,

I have a problem: i have to write this
((1/(1+0.38))^2)*2.678
((1/(1+0.38))^3)*1234.445
((1/(1+0.38))^4)*14.5677
((1/(1+0.38))^5)*2.35
((1/(1+0.38))^6)*9.786
((1/(1+0.38))^7)*3.567
......

for 100 times but i don't knw how to do that. is there any kind of formula
or option to do that?? the dragging stuff doesn't work

thanks
 
You can use this

=((1/(1+0.38))^(ROW(A1)+1))*2.678

Why these numbers are multiplied 2.678, 1234.445 ??
 
Murdock85 said:
I have a problem: i have to write this
((1/(1+0.38))^2)*2.678
((1/(1+0.38))^3)*1234.445
[....]
for 100 times but i don't knw how to do that. is there any kind of
formula or option to do that?? the dragging stuff doesn't work
Click to expand...

If you want a column of formulas of that form, and the constants 2.678,
1234.445 etc are in B3:B102 for example, then put the following formula into
C4, for example, and copy (or drag) down through C103:

=B3 / (1+0.38)^(ROW(B3)-ROW($B$3)+2)

However, if your intent is to sum the resulting column (ostensibly C4:C103),
you could write the following single array formula:

=B3:B102 / (1+0.38)^(ROW(B3:B102)-ROW(B3)+2)

Note that an array formula is committed by pressing ctrl+shift+Enter instead
of Enter. If you make a mistake, you can press F2, then press
ctrl+shift+Enter. An array formula will be displayed with curly braces
around it in the Formula Bar, i.e. {=formula}.

And if your intent is to sum the series, you could use the NPV function if
you can prefix the column of constants with a cell containing zero; for
example, 0, 2.678, 1234.445 etc in B2:B102. Then the sum is simply:

=NPV(0.38, B2:B102)

Change the format if you do not want Currency.


----- original message -----
 
Murdock85 said:
I have a problem: i have to write this
((1/(1+0.38))^2)*2.678
((1/(1+0.38))^3)*1234.445
[....]
for 100 times but i don't knw how to do that. is there any kind of
formula or option to do that?? the dragging stuff doesn't work
Click to expand...

If you want a column of formulas of that form, and the constants 2.678,
1234.445 etc are in B3:B102 for example, then put the following formula into
C4, for example, and copy (or drag) down through C103:

=B3 / (1+0.38)^(ROW(B3)-ROW($B$3)+2)

However, if your intent is to sum the resulting column (ostensibly C4:C103),
you could write the following single array formula:

=B3:B102 / (1+0.38)^(ROW(B3:B102)-ROW(B3)+2)

Note that an array formula is committed by pressing ctrl+shift+Enter instead
of Enter. If you make a mistake, you can press F2, then press
ctrl+shift+Enter. An array formula will be displayed with curly braces
around it in the Formula Bar, i.e. {=formula}.

And if your intent is to sum the series, you could use the NPV function if
you can prefix the column of constants with a cell containing zero; for
example, 0, 2.678, 1234.445 etc in B2:B102. Then the sum is simply:

=NPV(0.38, B2:B102)

Change the format if you do not want Currency.


----- original message -----
 
since i have to multiply =((1/(1+0.38))^(ROW(A1)+1)) for changing cells.
i mean i should have

=((1/(1+0.38))^1)*B3
=((1/(1+0.38))^2)*C3
=((1/(1+0.38))^3)*D3
=((1/(1+0.38))^4)*E3
=((1/(1+0.38))^5)*F3
.....
untill 100
 
=((1/(1+0.38))^1)*INDIRECT(ADDRESS(3,ROW()-1))


since i have to multiply =((1/(1+0.38))^(ROW(A1)+1)) for changing cells..
i mean i should have

=((1/(1+0.38))^1)*B3
=((1/(1+0.38))^2)*C3
=((1/(1+0.38))^3)*D3
=((1/(1+0.38))^4)*E3
=((1/(1+0.38))^5)*F3
....
untill 100







- Show quoted text -
Click to expand...
 
i don't have to sum any cell. i just have to have =((1/(1+0.38))^1)*A1 in one
cell and in the right cell ((1/(1+0.38))^2)*B1 and again in the right cell
((1/(1+0.38))^3)*C1...... till ((1/(1+0.38))^100)*CV1

if i drag excel changes the cell i multiply( i mean A1,B1,C1,....,CV1) but
it mantains perfectly identical this part =((1/(1+0.38))^1). i need that both
change (the cell and the value after ^)

Joe User said:
Murdock85 said:
I have a problem: i have to write this
((1/(1+0.38))^2)*2.678
((1/(1+0.38))^3)*1234.445
[....]
for 100 times but i don't knw how to do that. is there any kind of
formula or option to do that?? the dragging stuff doesn't work
Click to expand...

If you want a column of formulas of that form, and the constants 2.678,
1234.445 etc are in B3:B102 for example, then put the following formula into
C4, for example, and copy (or drag) down through C103:

=B3 / (1+0.38)^(ROW(B3)-ROW($B$3)+2)

However, if your intent is to sum the resulting column (ostensibly C4:C103),
you could write the following single array formula:

=B3:B102 / (1+0.38)^(ROW(B3:B102)-ROW(B3)+2)

Note that an array formula is committed by pressing ctrl+shift+Enter instead
of Enter. If you make a mistake, you can press F2, then press
ctrl+shift+Enter. An array formula will be displayed with curly braces
around it in the Formula Bar, i.e. {=formula}.

And if your intent is to sum the series, you could use the NPV function if
you can prefix the column of constants with a cell containing zero; for
example, 0, 2.678, 1234.445 etc in B2:B102. Then the sum is simply:

=NPV(0.38, B2:B102)

Change the format if you do not want Currency.


----- original message -----

Murdock85 said:
hello everybody,

I have a problem: i have to write this
((1/(1+0.38))^2)*2.678
((1/(1+0.38))^3)*1234.445
((1/(1+0.38))^4)*14.5677
((1/(1+0.38))^5)*2.35
((1/(1+0.38))^6)*9.786
((1/(1+0.38))^7)*3.567
.....

for 100 times but i don't knw how to do that. is there any kind of formula
or option to do that?? the dragging stuff doesn't work

thanks
Click to expand...

.
Click to expand...
 
Murdock85 said:
i don't have to sum any cell. i just have to have =((1/(1+0.38))^1)*A1 in
one cell and in the right cell ((1/(1+0.38))^2)*B1 and again in the right
cell
((1/(1+0.38))^3)*C1...... till ((1/(1+0.38))^100)*CV1
Click to expand...

If you start in column A, the formula can be simplified to:

=A1 / (1+0.38)^COLUMN(A1)

But in another posting, you said that you start in B3. The more general
formula is:

=B3 / (1+0.38)^(COLUMN(B3)-COLUMN($B$3)+1)

Pay close attention to relative and abosute references in the latter
formula.


----- original message -----

Murdock85 said:
i don't have to sum any cell. i just have to have =((1/(1+0.38))^1)*A1 in
one
cell and in the right cell ((1/(1+0.38))^2)*B1 and again in the right cell
((1/(1+0.38))^3)*C1...... till ((1/(1+0.38))^100)*CV1

if i drag excel changes the cell i multiply( i mean A1,B1,C1,....,CV1) but
it mantains perfectly identical this part =((1/(1+0.38))^1). i need that
both
change (the cell and the value after ^)

Joe User said:
Murdock85 said:
I have a problem: i have to write this
((1/(1+0.38))^2)*2.678
((1/(1+0.38))^3)*1234.445
[....]
for 100 times but i don't knw how to do that. is there any kind of
formula or option to do that?? the dragging stuff doesn't work
Click to expand...

If you want a column of formulas of that form, and the constants 2.678,
1234.445 etc are in B3:B102 for example, then put the following formula
into
C4, for example, and copy (or drag) down through C103:

=B3 / (1+0.38)^(ROW(B3)-ROW($B$3)+2)

However, if your intent is to sum the resulting column (ostensibly
C4:C103),
you could write the following single array formula:

=B3:B102 / (1+0.38)^(ROW(B3:B102)-ROW(B3)+2)

Note that an array formula is committed by pressing ctrl+shift+Enter
instead
of Enter. If you make a mistake, you can press F2, then press
ctrl+shift+Enter. An array formula will be displayed with curly braces
around it in the Formula Bar, i.e. {=formula}.

And if your intent is to sum the series, you could use the NPV function
if
you can prefix the column of constants with a cell containing zero; for
example, 0, 2.678, 1234.445 etc in B2:B102. Then the sum is simply:

=NPV(0.38, B2:B102)

Change the format if you do not want Currency.


----- original message -----

Murdock85 said:
hello everybody,

I have a problem: i have to write this
((1/(1+0.38))^2)*2.678
((1/(1+0.38))^3)*1234.445
((1/(1+0.38))^4)*14.5677
((1/(1+0.38))^5)*2.35
((1/(1+0.38))^6)*9.786
((1/(1+0.38))^7)*3.567
.....

for 100 times but i don't knw how to do that. is there any kind of
formula
or option to do that?? the dragging stuff doesn't work

thanks
Click to expand...
Click to expand...
Click to expand...


----- another message -----
 
Back
Top