Nested IFS/Multiple Formulas

[ncrb_10]

Hello,

I am seeking help on the following problem:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]
[/TD]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]f[/TD]
[TD]g[/TD]
[TD]h[/TD]
[TD]i[/TD]
[TD]j[/TD]
[TD]k[/TD]
[TD]l[/TD]
[TD]m[/TD]
[TD]n[/TD]
[TD]o[/TD]
[TD]p[/TD]
[TD]q[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Upgrade 1[/TD]
[TD]Upgrade 2[/TD]
[TD]Upgrade 3[/TD]
[TD]# employees[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD]Jul[/TD]
[TD]Aug[/TD]
[TD]Sep[/TD]
[TD]Oct[/TD]
[TD]Nov[/TD]
[TD]Dec[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I need to write a formula for cells F2:Q2 that calculate the following:

For example - in cell F2

If F1 = A2 then F2=D3 + If F1 = B2 then F2=D3 = If F1 = C3 then F2=D3

So, let's say Cells A2:C2 all contained "Jan", then cell F2 would equal "9". On the other hand, based on the current values of cells A2:C:2, cell a2=3, g2=3, and h2=3.

Let me know if I need to clarify as I am aware this may seem confusing.

Thanks!

 

[jtakw]

Well, according to your OP, if you have 2 of the same Month in A2:C2, you'll need double the # of employees for the Month 3 months prior.

If that's no longer the case, Please post some samples with expected results.

 

[ncrb_10]

Well, according to your OP, if you have 2 of the same Month in A2:C2, you'll need double the # of employees for the Month 3 months prior.

If that's no longer the case, Please post some samples with expected results.

Nevermind, I found the issue.

However, I was wondering if there was a way to make a minor adjustment. Is there a way to adjust the formula so that the number of employees needed will be shown in each month leading up to the month of the upgrade. In other words, if I need 3 employees and the upgrade will take 3 months, and the month of the launch is August, I need the table to show 3 employees in May, June, and July.

One workaround is that I just multiply your original formula by the # months cell, but I would rather show the data in each month.

 

[ncrb_10]

Well, according to your OP, if you have 2 of the same Month in A2:C2, you'll need double the # of employees for the Month 3 months prior.

If that's no longer the case, Please post some samples with expected results.

[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[TD]
[/TD]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]f[/TD]
[TD]g[/TD]
[TD]h[/TD]
[TD]i[/TD]
[TD]j[/TD]
[TD]k[/TD]
[TD]l[/TD]
[TD]m[/TD]
[TD]n[/TD]
[TD]o[/TD]
[TD]p[/TD]
[TD]q[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Upgrade 1[/TD]
[TD]Upgrade 2[/TD]
[TD]Upgrade 3[/TD]
[TD]# employees[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD]Jul[/TD]
[TD]Aug[/TD]
[TD]Sep[/TD]
[TD]Oct[/TD]
[TD]Nov[/TD]
[TD]Dec[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Aug[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


That is what the table is showing using the formula you have provided. Why is that happening? It only occurs if all three cells A2:C2 do not contain a month.