Hi,

I need help with a formula. I am trying to calculate payments where
someone might buy something in three installments of $20. I would like
each month to automatically carryforward the remaining two payments.
How can I do this?

Thanks.

The formulas can be really simple (=A1+A2, for example) or more complex
depending on the layout of your data, or if there are any conditions to
apply. It is hard to give a concrete solution with the information you have
posted, if you can add some example of what you want to achieve that would
help.

Miguel.

" wrote:

Hi,

I need help with a formula. I am trying to calculate payments where
someone might buy something in three installments of $20. I would like
each month to automatically carryforward the remaining two payments.
How can I do this?

Thanks.

Thanks. Here is some more detail.

I am creating a spreadsheet that needs to perform the following kinds
of calculation:

X% of people will pay us X% of the selling price (for example, 50% will
pay us $100), while the remaining X% will pay us in X number of
installments (for example, the remaining 50% will pay us in 3 payments
of $33).

I need to be able to easily change the percentage that pays full price
and I need to be able to quickly alter the number of payments to
achieve full price.

Does this make more sense?

I am still not sure what is the final result expected. If it is the monthly
figure, for example, something like this may do (# of customers in B1, price
in B2, % of customers paying full in B3, number of payments in B4)
=B1*B2*B3+(B1*B2*(1-B3)/B4)

When you change cells B3 and B4, the results will change accordingly. Is
this what you needed?
Miguel.

" wrote:

Thanks. Here is some more detail.

I am creating a spreadsheet that needs to perform the following kinds
of calculation:

X% of people will pay us X% of the selling price (for example, 50% will
pay us $100), while the remaining X% will pay us in X number of
installments (for example, the remaining 50% will pay us in 3 payments
of $33).

I need to be able to easily change the percentage that pays full price
and I need to be able to quickly alter the number of payments to
achieve full price.

Does this make more sense?