How Many Times Can a Number Go Into Another Number

[djfatboyfats]

Good afternoon,

I need to work out how many times a number in cell A1 can go into the number is B1.

For example A1 = £50, B1 = £1000

The formula answer i want it to give me is 20

Thanks in advance

DJ

[twiggywales]

=b1/a1 ??

[nitin.asalkar]

see if following formula gives you a result you are looking for

=FLOOR(B1/A1,1)

[djfatboyfats]

Thanks guys