Formula Help

ronnie.johnson46086 · 04/25/18

Not easy to relay what i'm trying to do here...

I'm trying to establish a resource requirement list. We have 13 resources available for 4 categories.

Right now, I have each category set to cap at 13 resources based on volume per category(this can happen as these are fed via a separate formula). My issue is that I don't want the sum of the 4 cells to exceed that 13 number either. How can i do that?

Essentially, i want to be able to assign my resources by category but not exceed my max of 13.

L_123 · 04/25/18

=if({insert your current formula}>13,"Error: Greater than 13",{insert your current formula})

or you could hardlock it at 13 if it goes over by using:

=if({insert your current formula}>13,13,{insert your current formula})

ronnie.johnson46086 · 04/25/18

Is there a way i can set so that the combination of column b does not exceed a sum of 13 even if formulas are fed to each cell in the column?

L_123 · 04/26/18

other than in the formulas themselves no there isn't a way that I know of.

Formula Help

Comments

Help Article Resources

Categories