Hoping someone can assist with either a VB code or formula. In the attached sample file you'll see a dollar amounts in columns J & K. I need something that will look at column J and calculate/pay an amount based on $0.50 per $1.00 in each row, up to a maximum amount of $250.00, and place the figure in column L. If the calculated amount does not match what is in column K then place the difference between the two totals in column M. The concept is for the end user to look at column M and know how much remaining needs to be paid out.
For example, in the attached workbook:
L2 would equal $250.00 ($2110 * .50 = $1055 but max is $250.00). M2 would equal $100 (difference between L2 ($250) and K2 ($150)
L3 would equal $6.00 ($12.23 *.50 (dollar only) = $6.00. M3 would equal $6.00 since $0 in K3
Any assistance would be greatly appreciated!