Good Day,
If I have different totals in varying denominations example $55,500.00 in 100s and $300,000.00 in 50's: based on this information I want to be able to do a formula that helps me to distribute the total amount in pieces but the amounts should be rounded in 100s' to make a total:
For example: Total amount to be distributed for x location is 100,000.00 it should say for example 1000*50 and 500*100
If I have different totals in varying denominations example $55,500.00 in 100s and $300,000.00 in 50's: based on this information I want to be able to do a formula that helps me to distribute the total amount in pieces but the amounts should be rounded in 100s' to make a total:
For example: Total amount to be distributed for x location is 100,000.00 it should say for example 1000*50 and 500*100