Putting a formula in a cell and also allowing blank cell

If I have a cell with a formula in it, but I also want the cell to remain blank if the other dependent cell is also blank, how do I do this?

So my cell has this formula:
=((C3-E3)/C3)

But if E3 is blank, I want this cell to remain blank also.

How do I enter both the formula above plus the need to be blank?

JH

=if(e3="","",((c3-e3)/c3))

Originally Posted by MRUTOR

=if(e3="","",((c3-e3)/c3))

That's perfect, thanks.

If I want to have EITHER one of two cells blank before my formula, how do I do that?

So if either E3 is blank or G3 is blank, then make this blank, otherwise do the calculation.

JH

Try either: =IF(OR(g3="",e3=""),"",(c3-e3)/c3) or =IF(OR(g3="",e3=""),"",1-e3/c3)
Let us know if you have any questions.