How to write error into formula bar

[Mushroomman]

Hi,

I'm looking to write a nested IF formula which will be dependant on certain cells that have errors in them (because those error cells have a formula in them which can't formulate becuase the numbers needed for that formula haven't been entered yet).

For example.

Cell A1=#DIV/0!. Cell B1=5.

In cell C1 I want to calculate the average between A1 & B1, but there is an error in A1.

I'm trying to figure out how to make a formula which ignores an error and gives me the value in the cell which doesn't have an error. But I also need it to calculate the average if both cells have a value in it.

Thanks in advance,
Paul

 

[Mushroomman]

Just copped onto something. I just used an IFERROR formula in front of it so that it turns blank when theres an error!