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" <Darren@discussions.microsoft.com> wrote in message
> news:56351AB3-8108-40C8-AF82-424EEB250B2A@microsoft.com...
> > =IF(B3:K3<=3,"Please enter the reason for 3's and less","Thank You") The
> > cells B3 through K3 are valid cells.
>
>
>

Hi Darren,

Instead try:

=IF(MIN(B3:K3)<=3,"Please enter the reason for 3's and less","Thank You")

confirmed with Enter.


---
Regards,
Norman



"Darren" <Darren@discussions.microsoft.com> wrote in message
news:20521EE5-E580-461F-B456-29DF61983956@microsoft.com...
> 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" <Darren@discussions.microsoft.com> wrote in message
>> news:56351AB3-8108-40C8-AF82-424EEB250B2A@microsoft.com...
>> > =IF(B3:K3<=3,"Please enter the reason for 3's and less","Thank You")
>> > The
>> > cells B3 through K3 are valid cells.
>>
>>
>>

Norman, thanks for the modification. Question however...
Noticed your Original approach indicated a CSE array
formula required,

Your modified one "does not"; Can you explain why
I've been unable (yet) to get my mind around the difference in the above
two.
Tks in Advance.
Jim




"Norman Jones" <normanjones@whereforartthou.com> wrote in message
news:ewchIte2FHA.2268@TK2MSFTNGP15.phx.gbl...
> Hi Darren,
>
> Instead try:
>
> =IF(MIN(B3:K3)<=3,"Please enter the reason for 3's and less","Thank You")
>
> confirmed with Enter.
>
>
> ---
> Regards,
> Norman
>
>
>
> "Darren" <Darren@discussions.microsoft.com> wrote in message
> news:20521EE5-E580-461F-B456-29DF61983956@microsoft.com...
>> 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" <Darren@discussions.microsoft.com> wrote in message
>>> news:56351AB3-8108-40C8-AF82-424EEB250B2A@microsoft.com...
>>> > =IF(B3:K3<=3,"Please enter the reason for 3's and less","Thank You")
>>> > The
>>> > cells B3 through K3 are valid cells.
>>>
>>>
>>>
>
>

Min works with a range - you are only interested in a single value contained
in that range

If(rng<=3, ,)

would generate an array of true or false, one for cell in rng based on
whether that cell is less than or equal to 3.

Put some numbers in F1 to F10
select a cell, then put this formula in the formula bar

=IF(F1:F10<=3,1,0)

go to the formula bar and select the F1:F10<=3 portion of the formula and
hit F9

You will see the array. Hit escape.

Now select the whole formula and hit F9

You will see the array of 1 and zeros returned by the IF function. Hit
Escape.

Now put in

=Max(F1:F10)

It returns a single number. So do you want to make a decision on a per
cell basis (array formula) or do you want a decision across a range of
cells.

--
Regards,
Tom Ogilvy


"Jim May" <jmay@cox.net> wrote in message
news:79K7f.21843$OM4.18391@dukeread06...
> Norman, thanks for the modification. Question however...
> Noticed your Original approach indicated a CSE array
> formula required,
>
> Your modified one "does not"; Can you explain why
> I've been unable (yet) to get my mind around the difference in the above
> two.
> Tks in Advance.
> Jim
>
>
>
>
> "Norman Jones" <normanjones@whereforartthou.com> wrote in message
> news:ewchIte2FHA.2268@TK2MSFTNGP15.phx.gbl...
> > Hi Darren,
> >
> > Instead try:
> >
> > =IF(MIN(B3:K3)<=3,"Please enter the reason for 3's and less","Thank
You")
> >
> > confirmed with Enter.
> >
> >
> > ---
> > Regards,
> > Norman
> >
> >
> >
> > "Darren" <Darren@discussions.microsoft.com> wrote in message
> > news:20521EE5-E580-461F-B456-29DF61983956@microsoft.com...
> >> 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" <Darren@discussions.microsoft.com> wrote in message
> >>> news:56351AB3-8108-40C8-AF82-424EEB250B2A@microsoft.com...
> >>> > =IF(B3:K3<=3,"Please enter the reason for 3's and less","Thank You")
> >>> > The
> >>> > cells B3 through K3 are valid cells.
> >>>
> >>>
> >>>
> >
> >
>
>