Hi everyone- I'm having a problem with a formula for work. Attached is a simplified version of my problem.



My job is to find the %s of all insured cars, based on two different types of insurance. However, one insurance (type A) runs out before the other, and when that happens we use a forecasted/projected amount. I created a simple IF formula to show the insured % amounts for the next three months. If theres a value in type A insurance, use total insured cars/total cars. If there isn't a value in Type A, use total insured cars/total cars + forecast A. This formula breaks down in the months of Sept and Oct (if you look at the comments in the attached wrkbook).


Thanks for any and all help!

xpost- http://www.excelforum.com/excel-gene...html?p=2880458

Attached Files

Testbook.xlsx (12.9 KB, 22 views)