I am a bit confused or maybe I confused everyone.
This is what I need. I have cell where I place :
A B C D
example distributor $amount Commission $
1 PSS 100,000 B4 *C1
2 n/a 85,000 C2
3 Avanti 180,000 B5 *C3

RANGE
4 PSS 75%
5 Avanti 90%
6 ASA 75%