here we go,

what i would like to do is take the value in g20 and m20 add them
together and take the average..BUT... if m20 equals #DIV/0! i still
want g20 to calculate..

ie- g20= 30 and M20= 30 then C20=30, this is good
ie- g20= 30 and M20= #DIV/0! then C20=30, this is good

But what i am getting is,

G20= 30 and M20= #DIV/0! then C20=15, this is not
good

any suggestions?


--
fivermsg
------------------------------------------------------------------------
fivermsg's Profile: http://www.excelforum.com/member.php...o&userid=32348
View this thread: http://www.excelforum.com/showthread...hreadid=521216