Excel Auditing formula

[Chris]

I am having trouble with a formula within excel,
basically I need the formula to calculate the amount of
money it would cost if I had so many reference points,

So : the single numbers which are 1,2 etc. are the number
of buildings and the reference points are staff

1 and 750 - £6112.5
2 and 750 £12250.00
3 and 750 - £17430
4 and 750 - £23542.5
1 and 1500 - £12250.00
2 and 1500 - £23542.5
3 and 1500 - £26917.50
4 and 1500 - £30292.5

these are my reference point queries I have worked out
that one reference point is going to be costing
£8.66666666666666667

So this is the code I have already

=IF('No. Of Staff'<750,"£6112.50",IF('No. Of
Staff'>751,"£12250.00",IF('No. Buildings'<1,"£6112.50",IF
('No. Buildings'>2,23542.5))))

which only brings up 12250.00, So if i had 1 building and
10000 staff I need to know how much it would cost using a
formula

Can anyone help

 

[GB]

Chris - I can't figure out what you actually want?

The way you have it programmed, if the staff size is 749 or less, you always
get £6112.50 regardless of the No. of buildings.

If staff size is 751 or more, you always £12250 regardless of buildings

Only if staff is exactly 750 does your formula consider the number of
buildings.

NB: Excel takes '<' literally. So Buildings <1 means Buildings = 0 (assuming
you can't get part of a building). You may mean to use <=1 which means 0 or
1 buildings.

I am sure it is easy to construct the formula in Excel if only it was
clearer what you are trying to achieve.

Geoff



I am having trouble with a formula within excel,
basically I need the formula to calculate the amount of
money it would cost if I had so many reference points,

So : the single numbers which are 1,2 etc. are the number
of buildings and the reference points are staff

1 and 750 - £6112.5
2 and 750 £12250.00
3 and 750 - £17430
4 and 750 - £23542.5
1 and 1500 - £12250.00
2 and 1500 - £23542.5
3 and 1500 - £26917.50
4 and 1500 - £30292.5

these are my reference point queries I have worked out
that one reference point is going to be costing
£8.66666666666666667

So this is the code I have already

=IF('No. Of Staff'<750,"£6112.50",IF('No. Of
Staff'>751,"£12250.00",IF('No. Buildings'<1,"£6112.50",IF
('No. Buildings'>2,23542.5))))

which only brings up 12250.00, So if i had 1 building and
10000 staff I need to know how much it would cost using a
formula

Can anyone help