auto percent split and dollar value results

[jitterbug888]

Hello!

I want to take the invoice amount here, in F.
and be able to type a percentage in either column L or M, to split up the invoice amount out of 100%. So if either L or M get 55%, the other column automatically filled with 45%...
and the corresponding columns N and O get filled with the dollar value of the invoice amount. IF invoice were $100 the break up would be $55 and $45 if column L was 55%...
No need to deal with the GST at this stage...

attached spreadsheet.

Screenshot_20200422100839.png

thank you!