{ Symbol in Formula Bar

[waldz]

Guys, I'm stumped! I've been working on this issue since yesterday but lack the understanding to get around it.

My issue is with this formula in particular:

=MIN(IF([@[max dim]]<=priceSchedule[Max Dim],
IF([@[median dim]]<=priceSchedule[Med Dim],
IF([@[min dim]]<=priceSchedule[Min Dim],
IF([@[package weight]]<=priceSchedule[Actual Weight Limit], priceSchedule[Size '#],MAX(priceSchedule[Size '#]))))))

When applying the formula in a table I get weird results. Let me explain some more:

1) https://www.awesomescreenshot.com/image/3646528/be9b8526ae02c66e19493b0838ea6a41

I then hit the return key in the formula bar, and:

2) https://www.awesomescreenshot.com/image/3646518/69944f967267346ddd06b06b8d2eff85

Any ideas?

 

[JazzSP8]

It's an array formula.

You need to press CTRL, SHIFT and ENTER - Not just enter

 

[waldz]

Why thanks! Mystery solved. I guess the harder I tried, the dumber I looked

About 8 hours lost to that little conundrum!

 

[JazzSP8]

I can't remember the exact reason for my signature now, but it was over something I spent way too much time on when the answer was ridiculously simple LOL

We've all been there at one point or another!