"#DIV/0!" ----->>> I'd like the best way to check for Error.Type into my formula.....

[Bil Reese]

Using Excel automation, my vb program puts this formula into a range:

formula =
"=100*(1-(AVERAGE(C3,E3,G3,I3,K3,M3,O3,Q3,S3)/AVERAGE(B3,D3,F3,H3,J3,L3,N3,P
3,R3)))"

on rare occasions inside the cells this formula refers to, I find this error
message in one of those cells
"#DIV/0!"

how do I put a conditional formula into my statement to change this error
result value to
a very low number (as low as possible, such as .000000000001, or lower) ?

I know I can do something like this:
=IF(ERROR.TYPE(L2)=2,1,0)
to test for the "#DIV/0!" condition...

but what would be the best way to put the logic into the logic that assigns
to the formula variable above..

thank you very much
BR