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 Co...
OliverScheurich
Nov 11, 2021Gold 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.