I have a maintenance worker for every 5 sites with a salary of $ 3,500 per
month. Additional sites come on stream every month so once I hit the 6th site
in month 5 I will now need two maintenance workers and the salary line on my
P&L will now be $ 7,000 instead of $3,500. Sorry but I didn't understand your
initial formula.

Thanks

"T. Valko" wrote:

Shorter:

I need to continue this process up to "between 71 and 80"

Assuming the referenced cell will never exceed 80:

=CEILING(A5,10)/10*A1

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Try this:

=IF(A5="","",A1*MATCH(A5,{0,11,21,31,41,51,61,71}) )

--
Biff
Microsoft Excel MVP


"OrcaFire" wrote in message
...
If the cell I am referencing is between 1 and 10 I want my value to be
CellA1
X1
If the cell I am referencing is between 11 and 20 I want my value to be
CellA1 X2

I need to continue this process up to "between 71 and 80"

How would I write this IF function?

Thank you for your help.