|How complex is the existing calculation? Depending on the complexity, you can use it directly nested in an if/then function. |
Format would be like this:
=if(EXISTING_FUNCTION > 100, EXISTING_FUNCTION, 100)
an example would be as follows:
=if(sum(A3:A135)>100, sum(A3:A135), 100)
Let me know if you still have questions.
IT Desktop & Network Consultant - MOS Master Certified, MCP, MCSA, MCITP - Windows 7, CCNA Certificate Pending, A+, Network +