Posts by karinashe

    Does anyone have a formula that can be used in excel to break out currency. I would like to be able to put the amount in the first column and then have excel break out the amount into $20, $10, $5, $1, quarters, dimes, nickels, pennies...in other words, letting me know how many of each denomination I must get from the bank to amount to the total of what is in each column of figures. I have tried several different formulas, but none work unless I change it for each amount entered:( I am going out of town, would appreciate an answer to my e-mail address [email protected]