TRUE / FALSE for 3 criteria includung a max value in a range

[matratus34]

Hi,
I’m looking to return a TRUE or FALSE in a cell based on the values in 2 cells and then the highest value in a ranges of cells.

I’ve been playing around with MAX, IF and AND but with no luck.

To try and simplify my problem let’s say cell A1 has a sales value that needs to be over £100,
Cell B1 has a number of customers that needs to be over 5 but then cells C1:G1 contain percentages but I’m only interested in the range as long as the highest percentage number (in a single cell) in that range is below 30%.

Is there any way of putting that into one formula?

Any help would be greatly appreciated.
Thanks

 

[steve the fish]

See if this works:

=IF(AND(A1>100,B1>5,MAX(C1:G1) < 0.3),TRUE,FALSE)

 

[matratus34]

Thank you - works perfectly!