Annual cost calculation based on changes.

**sekharyadav** · 04-20-2013, 07:38 AM

Hi ,

I need either formula or macro to get correct result for attached sheet.

I have sheet with 2 criterias.

1. current level (COLUMN E) and current annual cost and monthly cost is calculating(from COLUMN J - U) based on current level anual cost
2. When i changed proposed level (COLUMN G) , proposed anual cost also will change and monthly cost should calculate based on role change month (COLUMN I).

for example role change month is APR, from Jan - Mar monthly cost need to calculate on current level and from APR onwards should be as per proposed annula cost for next months also.

Could you please help me.

Thanks,
Sekhar.

**kvsrinivasamurthy** · 04-20-2013, 09:52 AM

Pl see the attached file.

Cells J3 to U3 are changed as date but display is only month.(Do not Change it)
Formula in J4 can be dragged across and down words.

**etaf** · 04-20-2013, 10:16 AM

for 2 - you need to put in as dates (and format as required) and then use >= rather than just = as that will only use the one month

i have changed the dates and reformated to just show month
also change the formula IF to >=

I only changed row 4 and the months
not sure on the rest of the rows as a different formula