IF Statement Help

[cynde623]

Hi Community,

I really could use your help to figure out what I am doing wrong.  Please see my issue below.

=IF('Salary Cap Cost Share Cal'!$J$7="Yes",Year_1!F7*(1+SETUP!B18)),('Salary Cap Cost Share Cal'!J$7="N",Year_1!F7*(1+SETUP!B17)))

I want the result to either return no annual increase of 3% and value stays $199,300 or if "N" return 3% increase with a value of $205,279.

Please help me figure out what I am doing wrong.

Thanks,

[#2]

@cynde623 

=IF('Salary Cap Cost Share Cal'!$J$7="Yes",Year_1!F7*(1+SETUP!B18),IF('Salary Cap Cost Share Cal'!J$7="N",Year_1!F7*(1+SETUP!B17)))

I entered above formula and it seems to work.

[#3]

@cynde623 

Thank you so much! It workd