If statement that only returns #value, however it works in another spreadsheet but has {}

**michael_bemis2002** · 08-01-2012, 03:52 PM

So I am working on a spreadsheet with a sum with several if statements. In the original spreadsheet it works just fine. I copy the formula to a new spreadsheet and it will only return #value. In the original spreadsheet the formula has{=formula}. If the {} are removed then it also returns #value. If you undo that and the {} returns it works just fine. I have no idea why the {} is there or what it means.

I have also tried the sumif statement, but I have several if statements requried to return the value i am looking to sum. Any assistance would be apprciated.

Thanks,
Mike

**TMS** · 08-01-2012, 03:56 PM

If it has curly brackets, it is an array formula and has to be committed with Ctrl-Shift-Enter rather than just Enter.

Regards, TMS

**K m** · 08-01-2012, 03:56 PM

That signifys that the formula is an ARRAY

The formula must be entered using CTRL SHIFT ENTER instead of ENTER

You don't enter the { }, Excel enters them for you when you press CTRL SHIFT ENTER

Kirk

Change the title to [SOLVED] and click on the star at the end of this message for feedback

**Ace_XL** · 08-01-2012, 03:56 PM

the {} represent an array formula that are confirmed with Ctrl+Shift+Enter and not just Enter

Hence the anomaly. Some reading on array formula below..

www.cpearson.com/excel/array.htm

If statement that only returns #value, however it works in another spreadsheet but has {}

LinkBack

Thread Tools

Rate This Thread

Display

If statement that only returns #value, however it works in another spreadsheet but has {}

Re: If statement that only returns #value, however it works in another spreadsheet but has

Re: If statement that only returns #value, however it works in another spreadsheet but has

Re: If statement that only returns #value, however it works in another spreadsheet but has

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions