Good afternoon,

I am trying to find a formula that when I select an option from a drop down box it creates the amount in the next box.
E.g. Joe blogs earns £500.00, the candidate amount is split between two recruiters AA & BB. When selecting AA from the drop down box I need £250 to appear in AA's column and £250 in BB's column

Is this possible?

Thanks in advance