Excel 2010 Mulitplying by Percentages based on True False values

welcome to the forum, Lewis. say your data is:
Data Range

	A
1	FALSE
2	TRUE
3	TRUE
4	TRUE
5	FALSE
6	FALSE
7	FALSE

then use:
=COUNTIF(A1:A7,TRUE)*0.1+1

format as percentage. upload a sample excel file with your desired results you wish to see if that doesn't help

would be an interesting formula to compound them in 1 formula. but i cant think of any at the moment. what you can do is probably do up another column that helps you. for eg in B1:
=IF(A1,1+0.1,1)
B2 & copy down:
=IF(A2,B1+B1*0.1,B1)

It is difficult to tell what exactly you want. Are all the values added going to be the same?

If they are all going to be the same then you could use the FV function which uses a constant interest rate and constant payments:

Formula:

Please Login or Register  to view this content.

This is another possibility:

	A	B	C
1	FALSE	100	=IF(A1=FALSE,"",B1+SUMIFS($B$1:B1,$A$1:A1,TRUE)*0.1)
2	TRUE	100	=IF(A2=FALSE,"",B2+SUMIFS($B$1:B2,$A$1:A2,TRUE)*0.1)
3	TRUE	100	=IF(A3=FALSE,"",B3+SUMIFS($B$1:B3,$A$1:A3,TRUE)*0.1)
4	TRUE	100	=IF(A4=FALSE,"",B4+SUMIFS($B$1:B4,$A$1:A4,TRUE)*0.1)
5	FALSE	100	=IF(A5=FALSE,"",B5+SUMIFS($B$1:B5,$A$1:A5,TRUE)*0.1)
6	FALSE	100	=IF(A6=FALSE,"",B6+SUMIFS($B$1:B6,$A$1:A6,TRUE)*0.1)
7	FALSE	100	=IF(A7=FALSE,"",B7+SUMIFS($B$1:B7,$A$1:A7,TRUE)*0.1)
8			=SUM(C1:C7)

Which gives:

	A	B	C
1	FALSE	100
2	TRUE	100	110
3	TRUE	100	120
4	TRUE	100	130
5	FALSE	100
6	FALSE	100
7	FALSE	100
8			360

Very nice, newdoverman, but did you perhaps mean:

=FV(10%,COUNTIF(A1:A7,TRUE),,100)*-1

with 100 as the 4th argument, not 3rd?

This is of course equivalent to:

=100*1.1^COUNTIF(A1:A7,TRUE)

Regards

@ XOR LX

This is where the question is ambiguous to say the least. The OP said that there were check boxes with values. 5 TRUE statements....does that mean 5 values with interest, or 1 value with 5 interests? Are all the values the same? If the values are all different, that will change the outcome again.

Using =FV(10%,COUNTIF(A1:A7,TRUE),100)*-1 the starting value is 0 and there are 3 payments of 100 with compounded interest

Using =FV(10%,COUNTIF(A1:A7,TRUE),,100)*-1 there no payments but a starting value of 100 with 3 interest payments.

Hmmm, good point!

Guess we'll have to wait for the OP to confirm.

Regards