Forum Discussion
Trouble with formulas MIN/MAX within IF statements
I'd like the result to be either the sum of the parts, or, if the parts exceed 100, 100. I've tried multiple variations of IF statements to get there, and tried including MIN/MAX within the IF state...
SergeiBaklan and Riny_van_Eekelen
A slight change to the MIN statement provided solved the problem. Instead of using
=MIN(100,SUM(D3,D6,D9,D12,D15,D18)), the cell range in my actual file, changing the 100 to 1 did the trick. So the properly constructed, working formula is now =MIN(1,SUM(D3,D6,D9,D12,D15,D18)), which caps the percentage at 100% or returns the actual summed result that is less than 100%.
Many thanks!