Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I Need an answer for this Formula
I am using excell 2007 & this formula works
{=IFERROR(AVERAGE(IF(MOD(COLUMN(G5:HC5)-COLUMN(G5),4)=0,IF(G5:HC50,G5:HC5))),0)} When i upload this workbook to a 2003 version this formula does not work I get {=_xinfl.IFERROR(AVERAGE(IF(MOD(COLUMN(G5:HC5)-COLUMN(G5),4)=0,IF(G5:HC50,G5:HC5))),0)} or somthing close to this Then in the cell with this formula has a NAME error WHY & HOW could i fix |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I Need an answer for this Formula
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:HC50,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. -- Biff Microsoft Excel MVP "Mike" wrote in message ... I am using excell 2007 & this formula works {=IFERROR(AVERAGE(IF(MOD(COLUMN(G5:HC5)-COLUMN(G5),4)=0,IF(G5:HC50,G5:HC5))),0)} When i upload this workbook to a 2003 version this formula does not work I get {=_xinfl.IFERROR(AVERAGE(IF(MOD(COLUMN(G5:HC5)-COLUMN(G5),4)=0,IF(G5:HC50,G5:HC5))),0)} or somthing close to this Then in the cell with this formula has a NAME error WHY & HOW could i fix |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I Need an answer for this Formula
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) "Mike" wrote: I am using excell 2007 & this formula works {=IFERROR(AVERAGE(IF(MOD(COLUMN(G5:HC5)-COLUMN(G5),4)=0,IF(G5:HC50,G5:HC5))),0)} When i upload this workbook to a 2003 version this formula does not work I get {=_xinfl.IFERROR(AVERAGE(IF(MOD(COLUMN(G5:HC5)-COLUMN(G5),4)=0,IF(G5:HC50,G5:HC5))),0)} or somthing close to this Then in the cell with this formula has a NAME error WHY & HOW could i fix |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculator Answer Doesn't Match Excel Answer | Excel Discussion (Misc queries) | |||
Formula gives me the same answer | Excel Discussion (Misc queries) | |||
i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
I need to get this answer 8 - 1.2 = 6.2 from a formula | Excel Worksheet Functions | |||
If and (and) formula to allow a zero answer | Excel Worksheet Functions |