Function wizard Problem

[downeyr]

I used the function wizard to create the following formula in cell K2:

=MIN(ABS(J2-(I3:I10)))
J2 contains value 25

I3:I10 Contains numbers 5.831, incrementing unevenly to approx 63

Cell I6 contains 25.204.

formula result should be .204 (J2-I6) This shows up in the functio
wizard. When the wizard is closed the cell contains 19.169 (J2-I3)

Anyone seen this discrepancy before

Attachment filename: profile check ramp z.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=61000

 

[Charles Williams]

The function wizard uses Evaluate internally. which always treats formulae
as array formulae, but the formula resulting from the function wizard is not
entered as an array formula.

To get the answer you want reennter the formula using Control/Shift/enter so
that it becomes an array formula and will then give you .204

Charles
______________________
Decision Models
The Excel Calculation Site.
www.DecisionModels.com

 

[kkknie]

I don't use the function wizard, so cannot comment on it, but I do se
the error.

Your formula is an array formula and must be entered usin
Ctrl-Shift-Enter. It will show up in the formula bar with { }'s aroun
it.

 

[downeyr]

Problem solved. Thank you all