Hello, I'm a bit stuck as I have to find a formula to apply more than one
rule into the smae formula that i am unsure of a would appreaciate some
assistance, my prolem is as follows:
I have a table of information
1 A B
2 Date Weight
3 October 301
4 October 120
5 December 156
6 October 410
7 December 522

With this I need to find a formula that will apply the following rules for
October only:

-If the weight in column B is below 167 then a flat rate per line of 25 is
applied but if the weight is over 167 then the weight is to be multipied by
0.15

then that is to be added to the rule (using the same data)

-If the weight in column B is below 400 then a flat rate per line of 20 is
applied but if the weight is over 400 then the weight is to be multipied by
0.05

plus

- the number of 'Octobers' * 14

So for each caluation there would be 2 either or calulations that would be
added togetherand then added to a (flat number figure, number of Octobers,
mulitpied by 14) all from the listed table. I am not sure how to combine a
countif formula with one that would calulate the either or number that i am
looking for.

Can any one help?


--
Jim