Nested IFS/Multiple Formulas

[ncrb_10]

Hello,

I am seeking help on the following problem:

a

b

c

d

f

g

h

i

j

k

l

m

n

o

p

q

1

Upgrade 1

Upgrade 2

Upgrade 3

# employees

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

2

Jan

Feb

Mar

3

<tbody>
</tbody>

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.

a

b

c

d

f

g

h

i

j

k

l

m

n

o

p

q

1

Upgrade 1

Upgrade 2

Upgrade 3

# employees

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

2

Aug

3

6

3

<tbody>
</tbody>

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.