Range

[Orangeanorak]

Grateful if you can give me the formula for the following please

If any number in the range L5:L50 is less than 0 show "Error!" in L1

Thank you

 

[Jonmo1]

Try

=IF(MIN(L5:L50)<0,"Error!","")

 

[Orangeanorak]

Try

=IF(MIN(L5:L50)<0,"Error!","")

Much appreciated Jonno1 - sorted!

 

[Orangeanorak]

Can I add a sound to this - a microsoft one will do