Greetings. I've spent a great amount of time this morning working on a
formula for the following.

I have a column (A) of 45 values which are distances between point "a" and
point "b".

I have the next column (B) as an Accounting Value which equals the cost to
move a cargo that distance listed in Column A.

Column C is the cost per mile - Column B divided by Column A

I now have to break down the average cost per mile in 100 mile increments.

I started with =Averageif(A9:A44,IF(A9:A44,100,IF(A9:A44,<201,,) ,C9:C44)

I've tried using the following operators found on various discussions boards
and books - AND - OR

I've tried =Average(IF(

I've tried just about anything I could find on boards, books etc and now I
just need to break away for a while to avoid frustration but I am hoping
some one out there could offer a little assistance.

I am pretty certain AND & OR only work with absolute logical values.

Mark