Forum Discussion
cynde623
Nov 11, 2021Copper Contributor
IF Statement Help
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 Replies
- cynde623Copper Contributor
Thank you so much! It workd
- OliverScheurichGold Contributor
=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.