G
Guest
I am trying to create a "simple" sum equation that will not pass a designated
value
I know the general equation =sum(a1:a10) (for example) but for billing
purposes I do not want this value to pass a "capped" amount.
So say if the sum of a1:a10 is 100 and the limit is 100, it just shows 100
Whereas if the sum of a1:a10 is 120 and the limit is 100 it still only shows
100
Is there a simple solution to this?
value
I know the general equation =sum(a1:a10) (for example) but for billing
purposes I do not want this value to pass a "capped" amount.
So say if the sum of a1:a10 is 100 and the limit is 100, it just shows 100
Whereas if the sum of a1:a10 is 120 and the limit is 100 it still only shows
100
Is there a simple solution to this?