Function Argument box displays the correct formula result however the cell shows 0?

**Lloydiesuk** · 08-01-2013, 10:57 AM

Hi,

The formula in question is =IF(ISERR(AVERAGE(IF(C3:C14>0,C3:C14))),0,AVERAGE(IF(C3:C14>0,C3:C14))).

The formula agrement box shows the correct answer for the column which in this case is 3.9 but the cell displays 0.0!!

Can anyone help?

Thanks

**duffry** · 08-01-2013, 11:23 AM

Looks like an array formula. Try selecting the cell, pressing F2 and then holding Ctrl + Shift when you press Return.

**Lloydiesuk** · 08-02-2013, 04:01 AM

So simple - many thanks..

Function Argument box displays the correct formula result however the cell shows 0?

LinkBack

Thread Tools

Rate This Thread

Display

Function Argument box displays the correct formula result however the cell shows 0?

Re: Function Argument box displays the correct formula result however the cell shows 0?

Re: Function Argument box displays the correct formula result however the cell shows 0?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula in Function Arguments shows correct result but generates #VALUE! In cell

Formula result correct, but shows up incorrectly in cell

[SOLVED] Function Arguments result correct but cell shows 0?

Formula Result in Formula Box is Correct, Cell Shows 0

Valid formula result in Function Box but Cell displays #VALUE

Bookmarks

Bookmarks

Posting Permissions