Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
JM JM is offline
external usenet poster
 
Posts: 37
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"