value limit for a complex formula


New Member

I have a complex formula that I am using for calculation of potential for employees receiving a bonus. It is based on limits of percentages. The formula looks like this:
In essence there is a drop down with the words in this formula as values. That said once I get to a certain percentage, I need this cell to not go any higher. C29 as listed is based on a calculation of another cell. In this case I need C29 to never be more than 60% of 150% of this other cell.

Is there a way to get the final condition on this formula, or do I need to do some other background cells that would limit the calculation differently?



Well-known Member

Within your formula, you will need to replace C29 by

Hope this will help

Some videos you may like

This Week's Hot Topics