What is wrong with this formula?
Hi Gary,
Quite correct - my error.
Simply:
=IF(MIN(B3:K3)<=3,"Please enter the reason for 3's and less","Thank You")
---
Regards,
Norman
"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
only works if b3 3 for me.
--
Gary
"Norman Jones" wrote in message
...
Hi Darren,
The formula works for me.
The formula is an array formula and should be confirmed with :
control - shift - enter
---
Regards,
Norman
"Darren" wrote in message
...
=IF(B3:K3<=3,"Please enter the reason for 3's and less","Thank You")
The
cells B3 through K3 are valid cells.
|