I Need an answer for this Formula

M

Mike

I am using excell 2007 & this formula work
{=IFERROR(AVERAGE(IF(MOD(COLUMN(G5:HC5)-COLUMN(G5),4)=0,IF(G5:HC5>0,G5:HC5))),0)}
When i upload this workbook to a 2003 version this formula does not work I ge
{=_xinfl.IFERROR(AVERAGE(IF(MOD(COLUMN(G5:HC5)-COLUMN(G5),4)=0,IF(G5:HC5>0,G5:HC5))),0)} or somthing close to this
Then in the cell with this formula has a NAME error WHY & HOW could i fix
 
T

T. Valko

The IFERROR function can only be used in Excel 2007.

Try this array formula** :

=LOOKUP(1E100,CHOOSE({1,2},0,AVERAGE(IF(MOD(COLUMN(G5:HC5)-COLUMN(G5),4)=0,IF(G5:HC5>0,G5:HC5)))))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.
 
S

Sheeloo

IFERROR was introduced in Excel 2007... it is not available in Excel 2003.

You need to use ISERROR with IF to get similar functionality
Instead of
IFERROR( Your formula, value if error )
use
IF( ISERROR(Your formula), value if error, Your formula)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top