I have an excel file that uses formulas to calculate the percent of incentive generated. I have been asked to set up cell (G14) to never exceed 7% no matter what the values of cells C6,D6 and E11 are changed to. This is weird for me because the percentage should either go up or down depending on those values.
Can anyone help me figure out what can be done to lock this cell from exceeding 7%? here´s a link to the file http://1drv.ms/1El030y
Thanks
You just need to set a maximum value on it:
=min(0.07,F14+$F$11)