Nov 11 2021 09:16 AM
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,
Nov 11 2021 09:38 AM
=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.