View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Darren Darren is offline
external usenet poster
 
Posts: 137
Default What is wrong with this formula?

Perfect - that works with a small exception. I though I had it formulated to
check B3 through K3 and if any of those numbers fall at 3 or less, then it
would ask for a reason. The way it is working is only checking B3. Any help
on the getting it to work correctly?

"Norman Jones" wrote:

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.