amount plus percentage and then plus percentage formula

[Jagat Pavasia]

my A1 have amount
my b2 have percentage
my c2 have percentage
my d2 have percentage

i want answer in formula

i want answer in E2

25000+1% +1% +1% =25757.525

 

[duggie33]

How about this...

=A1*(1+B1)*(1+C1)*(1+D1)

 

[SanjayGMusafir]

Try this -

=((A2*(1+B2))*(1+C2))*(1+D2)

 

[Jagat Pavasia]

=A1*(1+B1)*(1+C1)*(1+D1)

thank youuuuuuuuuuuuuuuuuuuuu

 

[duggie33]

You're welcome. Glad we could help.

Doug

 

[Dave Patton]

T202309a.xlsm
	A	B	C	D	E
1	25000	1%	1%	1%	$25,757.53
2					$25,757.53
3
2a

Cell Formulas
Range	Formula
E1	E1	=FV(B1,3,,-A1)
E2	E2	=A1*(1+B1)^3

 

[SanjayGMusafir]

T202309a.xlsm
	A	B	C	D	E
1	25000	1%	1%	1%	$25,757.53
2					$25,757.53
3
2a

Cell Formulas
Range	Formula
E1	E1	=FV(B1,3,,-A1)
E2	E2	=A1*(1+B1)^3

@Dave Patton Both Formulae look good if Percent amount across cells remains constant.

 

[Dave Patton]

T202309a.xlsm
	A	B	C	D	E
1	25,000.00	1%	1%	1%	25,757.53
2					25,757.53
3
4
5	25,000.00	1.00%	1.25%	1.50%	25,949.11
6
7					25,949.11
8
2a

Cell Formulas
Range	Formula
E1	E1	=FV(B1,3,,-A1)
E2	E2	=A1*(1+B1)^3
E5	E5	=FVSCHEDULE(A5,B5:D5)
E7	E7	=((1+0.01)*(1+0.0125))*(1+0.015)*A5