Conditional divison based on cells result

[rohit_35]

Hello,

I am trying to divide a number in max 3 or 4 equal installments. If 3 is selected then 4th cell should return 0.

For example

If A1 is - 3 (no. of installments) drop down with max 4 installments allowed


If A2 is - 3000.00 (total amount) then

A3 - 1000
A4 - 1000
A5 - 1000
A6 - 0 (As sum of A3:A5= A2 i.e 3000)

If A2 is - 4000 then and A1 is 4 then

A3 - 1000
A4 - 1000
A5 - 1000
A6 - 1000 (max 4 installments are allowed)


Thank you.

[alansidman]

In A3 =$A$2/$A$1
A4 and A5 same as A3
In A6 =IF(A1=4,$A$2/$A$1,"")

[rohit_35]

Hey, that worked like a charm.

thank you so much for prompt reply.

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[rohit_35]

Hi,

I need to add 2, 3, 4 and 5 installments, to above calculation, please guide.

Thanks

[rohit_35]

Hello,



I am trying to divide a number in max 2, 3, 4, 5, 6 equal installments. If 5 is selected then 6th cell should return 0.

For example

If A1 is - 5 (no. of installments) drop down with max 6 installments allowed


If A2 is - 6000.00 (total amount) then

A3 - 1200
A4 - 1200
A5 - 1200
A6 - 1200
A7 - 1200
A8 - 0 (As sum of A3:A7= A2 i.e 6000)

If A2 is - 6000 then and A1 is 6 then

A3 - 1000
A4 - 1000
A5 - 1000
A6 - 1000
A7 - 1000
A8 - 1000 (max 6 installments are allowed)

I did got resolution for this in prev post, but that was for 3 and 4 installments only.


Thank you.

[davsth]

in a3 if(row()<$a$1+3,$A$2/$A$1,"")


eg row a3 is 3. if A1 is 1 you want the formula to calculate 3<4 so ok but the row below in a4 its not true

This will work for any number of instalments if you copy the formula down

[rohit_35]

Thanks for your reply, but this is not working.
getting no value in the cell

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook.

[davsth]

the cells are the same as those you describ in your example?

if you were in say a13 and not a3 the result would not work. Hence why an example is being asked for. for this to work the 3 in the formula would need to change to a 13

[rohit_35]

Its working....., but in blank sheet and not in my original one. trying to figure out the error....

[rohit_35]

I have attached a excel sheet, its working in new sheet but not in this one.

Thanks

[rohit_35]

solved, thanks i forgot to change the no of 3 to 18.