Forum Discussion

cynde623's avatar
cynde623
Copper Contributor
Nov 11, 2021

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,

 

 

 

 

Resources