Hi All,

If anyone can help, I'd greatly appreciate it. I’m trying to create a formula that says – If you select “Monthly” from the drop down list in column L, then the total cost in column K gets listed in each month (starting in column O) . If you select “Quarterly” then you have to select “Beg, Mid, End” in column M, then it would list the amount in column K to those months that are in the Beginning, Middle, or End of the Qtr. If you select “Annually” then you have to select the month it would be in from the drop down list in column M and then the total cost in column K would be picked up in that one month.. See attachment.

Formula.jpg