Not less than

[Guest]

I am trying to make a formula for staffing for my business.

Our minimum staffing in the store is 2 people
For every $50 in sales we need a person
if the sales are $150 we need 3
if the sales are $25 we still need

a1 Sales per man $50
a2 Sales 150
a3 People needed 3 (Formula a2/a1)

b1 Sales per man hour $50
b2 Sales $25
b3 People needed What is the formula?
(b2/b1 will give 1 - I need it to tell me atleast 2)

It seems to be an atleast or not less than but I do not know how to write it.
Can anyone give a simple solution?

Greatly appreciated!
JM

 

[David Biddulph]

=MAX(B2/B1,2)

 

[Dave Peterson]

=roundup(b2/b1,0)

Will round up to the next whole number.

 

[Guest]

=MAX(B2/B1,2)

 

[bigwheel]

The required formula should result in 2 + the number of extra staff based on
the sales. Two staff members are able to deal with $100 in sales so the
formula =2+IF(B2>100,(B2-100))/50,0) will only add extra staff members when
this figure is surpassed (and as it is will give fractions of staff which
you may need to modify)

 

[Roger Govier]

Hi

Try
=MAX(2,ROUNDUP(B1/B2,0))