Not less than
 

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

Not less than
 

=MAX(B2/B1,2)
--
David Biddulph

"JM" wrote in message
...
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

Not less than
 

=roundup(b2/b1,0)

Will round up to the next whole number.

JM wrote:

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

--

Dave Peterson

Not less than
 

=MAX(B2/B1,2)

"JM" wrote:

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

Not less than
 

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(B2100,(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)

"JM" wrote in message
...
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

Not less than
 

Hi

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

--
Regards

Roger Govier


"JM" wrote in message
...
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