Excel Magic Trick 325: Aggregate Daily Cost to Monthly Cost

TP-EQUIV="Refresh" CONTENT="0; URL=367811-what-bus-templete-do-i-use-for-daily-cost-w-daily-and-cum-cost.html"> Redirecting to this adress: 367811-what-bus-templete-do-i-use-for-dai

I am trying to figure out how to update cost from a vendors .xls file I want to compare my price list to the vendor price list by OEM number and Highlight any cost that have changed and show the amount of change. I have really tried and tried but I cannot figure out how to do the formula correctly. Any help would be greatly appreciated as I have to do this manually now and we have 4000 parts from this particular vendor.
Thank You
Matthew

In my provided Excel file it will be more clear what I want...

As I purchase an Item the cost increases 10%. I need the formula that will show the combined total cost of quantity purchased.

Thanks in advance
Dan

Can any one help please?
I'm trying to work a phone bill backwards. the calls cost .09p per min and I know the total cost of the call. I believe the calls are charged by the second. What I need to know is the time the call lasted.
I've had a look arounf the forum and can't see anything I can get to work. Can any one help this excel novice?
Thanks in advance for your help.

Apologies if the title is a little unclear, I'm sort of an excel newbie.

I'm trying to spread projected annual costs into monthly periods. I have a tab for the projected annual costs from 2010 - 2014 (these are where I want to make all my inputs), and then another tab that breaks down those costs into monthly periods.

Here's my problem: Some of the annual costs don't happen equally throughout the year, i.e. some of them start in Q2 or Q3. I want to be able to input the cost and start of the activity related to the cost and have those costs allocated automatically in the monthly breakdown tab.

For example:

Inputs:
Development cost: $1,200,0000
Start: Q3 2012

I want these inputs to show up on the next tab as a monthly $200,000 entry from July 2012 to December 2012 ($1.2 million spread over 6 months). What should the formula(s) be on this page?

Help on this is greatly appreciated.

How do I write an IF statement to calculate the monthly cost of care for a patient say from 3rd April through to 17th October

Hi All

I have a range of cells D12-D18 which contains either a positive number between 0 - 50,000 or a negative number between -1 to -20,000.
I need to find the mean daily costs in the range dependant on which is positive or negative

EG If cell D12,D14 has + number each unit which costs 5.67 cell D23 would display avearge cost

While cells D13,D15,D16,17,D18 HAS - NUMBERS,each -unit costs 5.03

Is there any way I can get the daily avearage to display in cells dependant on the positive /negative numbers input

Hope this makes sense

Any help welcomed

Have a nice day