=IF formula help

**JackVal** · 06-23-2019, 04:16 PM

if cell c2 contains "weekly" then cell g2 returns certain formula. however if cell c2 contains "monthly" or "yearly" then another formula is returned. currently just returns false. this is the formula i am currently trying

=IF(C2="Weekly",B2*52,0 =IF(C2="Monthly",B2*12,0 =IF(C2="Yearly",B2*1,0)))

**AliGW** · 06-23-2019, 04:18 PM

Welcome to the forum!

Try this:

=IF(C2="Weekly",B2*52,IF(C2="Monthly",B2*12,IF(C2="Yearly",B2*1,0)))

**JackVal** · 06-23-2019, 05:38 PM

Originally Posted by AliGW

Welcome to the forum!

Try this:

=IF(C2="Weekly",B2*52,IF(C2="Monthly",B2*12,IF(C2="Yearly",B2*1,0)))

Thanks that works perfectly. Is the only difference that you didn't put the false value until the end?

**Sam Capricci** · 06-23-2019, 08:23 PM

Is the only difference that you didn't put the false value until the end?

The problem with your formula was that you put in an "out" right away into the IF/THEN formula.
in your formula =IF(C2="Weekly",B2*52,0 =IF you essentially wrote that IF C2 = Weekly you wanted B2 to be multiplied by 52. IF it didn't equal weekly then make the output zero. So the formula had no reason to go beyond that point so the next IF formula was irrelevant because all conditions were satisfied initially.
BTW, this is a little shorter as a formula from what Ali gave you... =IF(C2="Weekly",B2*52,IF(C2="Monthly",B2*12,IF(C2="Yearly",B2,0))) Because the B2*1 is the same as B2.