Need formula with 2 different critirias

Hi Forum members,

Need help to get formula for attahced sheet.

2 critirias:

1 st one : based on DOJ (column C), montly cost (column F/12) display from J - U columns i.e DOJ is Jul means cost starts with July month and before months should be 0

2nd one : based on role change month, monthly cost should display based on proposed anual cost i.e F9/12 FROM Sep month onwards.

as per sheet, July - Aug cost based on current level cost /12 and September onwards propsed annual cost/12


Thanks,
Sekhar.

Hello Members,
Can any one help on my requirement. is any cofusion on my requirement pelase let me know?

Thanks,

IN J9, and drag.

Please Login or Register  to view this content.