How can I divide amount in proportionally in two segments?

[asolopreneur]

https://drive.google.com/a/writingline.com/file/d/1TLHGZw3XuXqn3CkziIjqDFwhjeaccopc/view?usp=sharing

Here you can see an example of what I want to achieve. Please let me know the simplest way to divide the value?

Thanks

 

[Special-K99]

I have to request access to open this file, thereby creating a delay.
Suggest you upload in some other fashion or you could be waiting a long time before getting a reply.

 

[asolopreneur]

Hey @Special-K99

Here is the link https://docs.google.com/spreadsheets/d/1NbwmB_Vtgkcb7x8NyjpUIlzR-oIANyBSHjVbcOv5t-I/edit#gid=0

 

[Special-K99]

in H6
=LEFT(G6,2)/100*D6

in I6
=RIGHT(G6,2)/100*D6

and copy down the columns

 

[asolopreneur]

Thanks @Special-K99 Exactly what I wanted.