I am working on a prize fund spreadsheet and had previously used the Floor Function. Unfortunately I protected the worksheet so that the person I was doing it for would not make changes to the formulas and I can not remember the password.
I can see part of the formulas, but not all of them since I can not change the column width.
Column B is the total cash for the team. Column C is the total per member (Col B / 4). Columns E to I break Col C down into $20's, $10's, $5's $1's & quarters. For Column E I have: =floor($c6/20,1)*4. For Column F: =floor(($c6-(( and that is all I can see. I think I subtracted the amount for the $20's, but I am not sure how I did it.
I would appreciate any help on this matter. I would use last year's sheet, but there is a cell that is protected that has information that had to be put in manually. I can't remove it and I can't add to the sheet, so right now I am stuck.
I can see part of the formulas, but not all of them since I can not change the column width.
Column B is the total cash for the team. Column C is the total per member (Col B / 4). Columns E to I break Col C down into $20's, $10's, $5's $1's & quarters. For Column E I have: =floor($c6/20,1)*4. For Column F: =floor(($c6-(( and that is all I can see. I think I subtracted the amount for the $20's, but I am not sure how I did it.
I would appreciate any help on this matter. I would use last year's sheet, but there is a cell that is protected that has information that had to be put in manually. I can't remove it and I can't add to the sheet, so right now I am stuck.