R

#### Rum

percentage formula.

Example:

Column A2 = Numerator

Column B2 = Denominator

Then for % formula I do the following in column A1:

=A2/B2

And this gives me a the cell A1 with percent formula but if the cells A2 and

B2 are blank then it gives "#DIV/0!".

Can we design this formula in such a way that the target cell (A1) remains

empty but still has the formula?

Also, how can I lock the formula cells so that no one can change it?

Please help.

Thanks