#name? Error

[bamaisgreat]

I created this formula in 2010 Excel and when I open it up in 2003 I get the error. Please Help! Thanks

=_xlfn.IFERROR(U4*K4*L4*M4*0.2835,"")

 

[VoG]

IFERROR was introduced in Excel 2007. Try

=IF(ISERROR(U4*K4*L4*M4*0.2835),"",U4*K4*L4*M4*0.2835)

 

[bamaisgreat]

Thank you. Im also getting that error with =IFERROR(VLOOKUP(R4,OPERATORS,2,FALSE),"")

 

[VoG]

Try

=IF(ISERROR(VLOOKUP(R4,OPERATORS,2,FALSE)),"",VLOOKUP(R4,OPERATORS,2,FALSE))

 

[bamaisgreat]

thanks Peter