Calculating employee raises and incentive raises

[JRP1218]

I am using this formula =(J5*((1 + I5)^C5)*E5) in Excel 2010 in Windows 7 enterprise to determine payroll raises and incentive raises. My problem is when E5=0 for no incentive raise then it returns "0". which I know anything multiplied by 0 will equal 0. SO how do I get the =(J5*((1 + I5)^C5) portion of the formula to process when E5 is 0? Where J5= start rate I5 is the percentage of raise C5 is the years employed and E5 the percentage of incentive raise. Works fine with everything except "0". Any help would be appreciated.

 

[bbott]

Welcome to the board. Try:

=IF(E5=0,1,E5)*J5*(1+I5)^C5

 

[JRP1218]

I can work with this. Thanks

 

[bbott]

I can work with this. Thanks

You're welcome.