Help with Formula (Excel 2003 SP3)

[steveh]

Hi all

I am trying to write a formula

=ISERROR(IF('Selected packaging'!A2=0,"No packaging solution available, please contact operations",'Selected packaging'!A2),"No packaging solution available, please contact operations"

If I enter it like this it says there is a paerntasis missing, if I add ) after operations") it says there are too many arguements, I just can't seem to get it right, would appreciate a pointer

[HansV]

I think you want

=IF(OR(ISERROR('Selected Packaging'!A2),'Selected Packaging'!A2=0),"No packaging solution available, please contact operations",'Selected Packaging'!A2)

[steveh]

I think you want

=IF(OR(ISERROR('Selected Packaging'!A2),'Selected Packaging'!A2=0),"No packaging solution available, please contact operations",'Selected Packaging'!A2)

Thanks Hans

I would have been there for a onth of Sundays, this packaging orientation workbook has already taken me about 10 months on and off!!