Cell range total cannot exceed another cell...

[BaddKarma]

New member, novice user, thanks in advance for any help...

I have a cell range w10=SUM(AB10:AE13) that I never want to exceed anther cells total a1.

So if a1 = 200, I would like the summed range of w10 to never to exceed 200.

regards,

BK

[martindwilson]

=min(a1,SUM(AB10:AE13))

[Cutter]

Welcome to the forum

In W10 place this formula:

=MIN(A1,SUM(AB10:AE13))

[BaddKarma]

Thank you very much! Worked like a charm.