Using Floor Function to do a cash breakdown

Maridw

New Member
Joined
Oct 6, 2013
Messages
7
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.
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,486
Office Version
  1. 365
Platform
  1. Windows
As Andrew said, we cannot help you with the password breaking part of it, but if the issue is you cannot change the column width to see the formula, there is another way you can see the formula with out changing the column width. Just select that cell and look at the formula in the Formula Bar.

I am also unlocking this thread so you can reply back to it. As long as no posts are made about password breaking, we will leave it unlocked.
 

Maridw

New Member
Joined
Oct 6, 2013
Messages
7
I am not trying to break the password. I never once asked for help to break the password, I was asking for help on the formula. This is MY spreadsheet that I created, but forgot the password. After many attempts to figure it out, I decided to re-create it the spreadsheet. I have tried to change the column width. But because the section I need to see is protected, it is not allowing me to change the width.

I was trying to see if someone was familiar with the function and how I might have used it to get this type of breakdown. If someone could help me with a similar formula using the Floor function, I would appreciate it. I have tried to click on the column heading and right clicking to get the drop down menu to change the column width but it is grey and will not allow me to select it.
 

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061

ADVERTISEMENT

Can you see the formula in the Formula Bar? That is not effected by Sheet protection.

Actually, can you even see the Formula Bar itself?
If not, show it by checking "Formula Bar" on the View Tab (xl2007+)
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,486
Office Version
  1. 365
Platform
  1. Windows
I am also unlocking this thread so you can reply back to it. As long as no posts are made about password breaking, we will leave it unlocked.
Sorry, I wasn't implying that you would post about that, but other people replying (if they misunderstand) might (it happens).
Actually, we would just remove those posts as opposed to locking the thread.
Sorry for the confusion.
 

Maridw

New Member
Joined
Oct 6, 2013
Messages
7
Thank you for all the replies. I was finally able to find a way to actually see the "code" of the worksheet and see the formulas within the code. When I had protected the sheet, I had set it up so that the person who was going to be using it could not even select the cells that I wanted protected. I had locked all those particular cells.

I have been able to create a new version and this time I wrote down the password and made it something associated with the sheet itself. ;)
 

Watch MrExcel Video

Forum statistics

Threads
1,109,322
Messages
5,528,007
Members
409,798
Latest member
Snake68

This Week's Hot Topics

Top