If statement Problem Choosing right cell to multiply if given criteria meet.

[excobra]

Hi,


I have three branches. Each start operation in different month Say Jan, Feb , March.

Monthly Sales of each branch is 15000.

When a new branch start operation it follows a predefined revenue percentage pattern. E.g. 10% in first month 20% in second 30% in third and so on and eventually it reach 100% revenue of 15000


I want to automate the revenue calculation table. Like if branch start operation it should automatically follow the Revenue %age pattern defined above. What i mean to say is first month of operation is different for each branch. Brach 1 started operations in Jan. Branch two started operations in Feb for branch2 first month of operation is Feb so it It should automatically take 10% of 15000 in first month of operation 20% of 15000 in 2nd and so on.

I have copied the link to the example File with answer which i have done manually. I want a formula for this


[FONT=source_sans_proregular]https://mega.nz/#!EpdECIqC!HjZkL93dmENLLz7OBtDtQeYLELxrS9W1CfRd4BQh5Go
[/FONT]

Please help

Regards

 

[MARZIOTULLIO]

Hi

Try

B15=IF(B4=1,$B$2*B4*B$10,"-") copy across and down

 

[excobra]

Thanks for the reply.

It didn't work but i spent some time and found the work around on my own.

i tried this in B15 =$B$2*B4*(IFERROR(INDEX($B$10:$M$10,MATCH(COUNTIF($B4:B4,"<>0"),$B$8:$M$8,0)),))

Thanks for the help anyway.
Much appreciated