View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Getting rid of error messages while using IF statements

Hello,

I have a series of relatively simple formulas, set up in a complex
manner that are returning errors on me.

I have an assumptions sheet that the first formula makes reference to.
Sometimes a cell in the assumptions will be blank, and sometimes it
won't as the data changes. the first formula is:

A10
=1/Assumptions!AB18

Now if the cell in Assumptions!AB18 happens to be blank, the next
formula will return a #DIV/0 error:

C10
=$A10*C$3

Finally, if there is a 0 or #DIV/0 in C10 then the formula in E10 will
error out as well.

E10
=IF(D10="",$A10*D$3,($A10-((D10/2)*$A10))*D$3)

I realize this may be troublesome to get the mind around. But is there
any way, in the last formula (E10) to tell it to do nothing if C10 is
blank? And the same for C10, and then the same for A10?