If , and , ......im struggling

[ZAIN1]

Hi

I want a formula that does the following:

If Cell C2 = Year 2 ($B$3), then Cell C3 = 60% and then D3 = 40% with E3, F3,G3 all zero

If Cell C2 does not equal B3 , then Cell C3 = 0



so if Cell D2 = $B$3 , then D3 =60% and E3 = 40% and all cells afterwards F3, G3, are zero.....and so on

 

[Joyner]

Hello and welcome to the board,

It sounds like you need several formulas not just one. When you say you want D3 =60% and E3 = 40% and all cells afterwards F3, G3, are zero, you will need a formula in each one of those cells to return the results, unless you use vba.

I don't know for sure what you want returned if D2 <> (not equal to) $B$3 but assuming you want "nothing" something like this in D3, E3, F3 and so on:

=IF(D2=B3,60%,"")
=IF(D2=B3,40%,"")
=IF(D2=B3,0,"")

If that is not what you are looking for, let me know.