Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 :-) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Number of items in a set | Excel Worksheet Functions | |||
How to sum a variable number of items | Excel Worksheet Functions | |||
Sum a different number of items | Excel Worksheet Functions | |||
number of items fit into item | Excel Worksheet Functions | |||
calculating 10 percentage of items in a column | Excel Discussion (Misc queries) |