# Floor

#### nicci113

##### New Member
Sorry if this Question is already been answered have looked quite a lot but couldn't find.

Last week at work I used this function(floor) to calc. number of for eg. 10 that comes under 100. Could you please let me know if you can give me the formula for it. So to explain properly. I give £5 to every 100th so if I have 1000 what formula to use so that it tell me the exact amount in ££? I used floor but can't remember and lost the logic and its really irritating me now. Any help on this is very much appreciated.

### Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

#### Marcol

##### Well-known Member
Maybe ...
Code:
``=INT(A2/100)*5``
Where A2 is your value to analyse

Is this what you mean?

#### VoG

##### Legend
Or if you want to use FLOOR perhaps

=FLOOR(A2/20,5)

#### nicci113

##### New Member
Or if you want to use FLOOR perhaps

=FLOOR(A2/20,5)

Wicked worked like a charm, I want to the reason for using "20"? Might be a bit daft Q but need to clarify by doubt

#### VoG

##### Legend

If you are giving 5 for every 100 that is one 20th. So, dividing by 20 gives you that value then the FLOOR function rounds it down to the nearest 5.

Cheers big man..

#### nicci113

##### New Member
aww cheers mate... Grand Thanks a lot much appreciated

Replies
11
Views
133
Replies
0
Views
175
Replies
3
Views
78
Replies
2
Views
300
Replies
4
Views
82