View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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.