Help

IF formula based on range/array of numbers across columns

Topic Labels: Formulas
Solved
Jump to Solution
854 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jon_Wright
5 - Automation Enthusiast
5 - Automation Enthusiast

I have 4 columns in my table, each containing numbers.
Screenshot 2022-10-20 at 17.01.38

In the Formula column called ‘Above Threshold’ I’m trying to create a formula that says if any of the values across the 4 columns is >100 output ‘Above’ and if <=100 output ‘Below’.

So something like this IF(({Total users (last 30d)},{Total users (prev 30d)},{Total users (last 90d-120d)},{Total users (last 120d-150d)},)>100, "Above", "Below")

That formula doesn’t work, so is there a way of doing it without using nested IF statements?

1 Solution

Accepted Solutions
Jon_Wright
5 - Automation Enthusiast
5 - Automation Enthusiast

Pretty sure I’ve worked it out by using ‘Max’.

IF(MAX({Users (last 30d)},{Users (last 30d-60d)},{Users (last 60d-90d)},{Users (last 90d-120d)})>=100, "Above Threshold", "Below Threshold")```

See Solution in Thread

1 Reply 1
Jon_Wright
5 - Automation Enthusiast
5 - Automation Enthusiast

Pretty sure I’ve worked it out by using ‘Max’.

IF(MAX({Users (last 30d)},{Users (last 30d-60d)},{Users (last 60d-90d)},{Users (last 90d-120d)})>=100, "Above Threshold", "Below Threshold")```