What do you mean "will just not work" or "it does not accept it"? You need
to give more information if you want help.

Do you get an error message; if so what? If you don't get an error
message, do you get a different result from what you expect? If so, what do
you get with which inputs and what did you expect? When you use
Control-Shift-Enter, does Excel put curly brackets {} around the formula in
the formula bar?

Are you trying to use Excel 97 or 2007? [You've mentioned both.]

Just one thought, does your Windows regional settings have a comma for a
list separator, or does it have a semi-colon?
--
David Biddulph

"Andes2U" wrote in message
...
Hi JP Thanks for the response.

=MIN(IF(U3:V30,U3:V3)) My typo. Array will just not work on my PC "
Microsoft Office 2007 Pro". I have forwarded my worksheet to a few people
and
it works with them but on my system.

Any suggestions


Andes

"JP" wrote:

1. You are missing a parenthesis. the formula should be
=MIN(IF(P3:Q30,P3:R3)) <-- note the closing ")"

2. When using an array formula, the arrays must be the same size. You
have a 2-cell range in the first argument, then a 3-cell range in the
second. Either make the first argument "P3:R3" or reduce the second
one to "P3:Q3"


HTH,
JP


On Nov 2, 3:32 am, Andes2U wrote:
=MIN(IF(P3:Q30,P3:R3)

I am using CTRL,SHFT and ENTER to enter this formula as an array but it
won't except it MS Office 97 "

If I copy an old formula as above from worksheet setup in 98 as soon as
I
enter array it does not accept it.