If any value bigger than 1 then

Hi Everyone,

I think i have a fairly simple question.
There is a list with in column P the values 1.
However, it might occur that values with 2 or more exist.

What i want is an if, that whenever a value higher than 1 is found, i can to the then things, otherwise end if.

Thanks!

Thanks Olly!

I was indeed looking for something like MAX but i didn't know how to put this in an if.

=IF(MAX(P1:P6)>1,"Do something","Not possible")

check this formula and let me know

Regards,
Mandeep baluja