View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Calculating number of items

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

-----Original Message-----
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 :-)
.