Good afternoon, I've been puzzling over this for quite a bit now. I have this formula which works perfectly untill such times as a nil value is part of the base data (as part of a seperate formula):

=AVERAGE(IF('Archived Trainees'!H8:H38="074-0",IF('Archived Trainees'!L8:L38="Complete - RTU",'Archived Trainees'!AP8:AP38))).

I know that I have to add in [Value if False] or an ISERROR however wherever I put it I get an error. Basically instead of #DIV/0 i would like it to return a dash "-". Thanks in advance.

Working from excel 2003.

=AVERAGE(IF('Archived Trainees'!H8:H38="074-0",IF('Archived Trainees'!L8:L38="Complete - RTU",'Archived Trainees'!AP8:AP38))).

I know that I have to add in [Value if False] or an ISERROR however wherever I put it I get an error. Basically instead of #DIV/0 i would like it to return a dash "-". Thanks in advance.

Working from excel 2003.

Last edited: