Calculating number of items

[Terry]

I have a sheet which calculates the values for maintenance on each
site we visit as follows;

Cost of mainteanace upto and including five items £20.00 anything over
five items is £15.00 per item.

i.e. 10 items

5 = £20.00 + 5 * £15.00 = £75.00 + £20.00 = £95.00

15 items

5 = £20.00 + 10 * £15.00 = £150.00 + £20.00 = £170.00

Each site is different, the initial cost covers arrival, What is the
formula?

Regards Terry

 

[Frank Kabel]

Hi
if your items are in cell A1 try
=20+MAX(A1-5,0)*15