referencing data to a table
 

I have a table reflecting how many members of staff are required per 450
customers. The first column therefore contains 450, 900, 1350, 1800 etc.
Adjacent each customer break is the number of staff required, 10, 20, 30, 40
etc. I want to create an equation which looks at a separate cell containing a
random number, reference this to the customer table and tell me how many
members of staff are required.

referencing data to a table
 

Maybe this:

A1 = some number

=CEILING(A1/450,1)*10


--
Biff
Microsoft Excel MVP


"tradebox" wrote in message
...
I have a table reflecting how many members of staff are required per 450
customers. The first column therefore contains 450, 900, 1350, 1800 etc.
Adjacent each customer break is the number of staff required, 10, 20, 30,
40
etc. I want to create an equation which looks at a separate cell
containing a
random number, reference this to the customer table and tell me how many
members of staff are required.