Solved How to set up a function [excel]

March 4, 2015 at 12:58:31
Specs: Windows Vista
I have calculated a value in a cell. If that value is greater than 100 then I want that value. If not, I want that cell to have 100 in it.

See More: How to set up a function [excel]

Report •

March 9, 2015 at 11:56:31
✔ Best Answer
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:


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 +


Report •
Related Solutions

Ask Question