EXCEL FORMULA HELP NEEDED PLEASE

[m3sye]

A B C
1 DEALS PER WEEK 10 10 10
2 NUMBER OF DIRECT DEBIT CUSTOMERS 6.5 6.5

Guys I want to work out a formula to forecast sales.

I need it to work out 65% of A1,2,3 Etc then populate that into A2,B2 etc

Now I know that is A1/100*65 but what I want it to do next is add the figure prior to it, ie B2 should read 13
6.5 for 65% + the 6.5 from the previous week

Hope that makes sense?

[Liszt]

If A2= A1/100*65
B2 =(B1/100*65) + A2

[m3sye]

Done it, thanks, I had worked it out correct myself ...

[amir_j]

Liszt said:

If A2= A1/100*65
B2 =(B1/100*65) + A2

confused still, thats a normall if formula you can do?

Can you take a screenshot and post as a pic? as ph layout and tables dont go.

[qureshia]

just add the field at the being of the calculation !

i.e original formula (assume this is in the field B1)

=A1/100*65

new formula (now in B2)

=B1+(A1/100*65)


if you copy and paste this down the B row excel with automatically incremental