On going formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stan W. - 10 Dec 2007 04:16 GMT

In Excel 2003 I am wanting to setup a formula where column C minus column B
with the answer in column D.
I wish to repeat this formula in an unknown number of rows where each column
will have a different value, and I also wish to hide the formula.
Can this be done?

Thanks
Stan W.

Reply to this Message

Brandt - 10 Dec 2007 04:53 GMT

Stan,

Are you wanting to do this in the worksheet or using VBA? In the worksheet
wouldn't this just be:

in cell D1: =C1-B1

Then drag down to cover the rows you are interested in. I hope this is not
an oversimplification of what you are doing (it probably is). Let me know if
I am misunderstanding.

As for hiding the formulas, select the desired cells, right click and select
"Format Cells" on the pop-up menu, click the "Protection" tab, check the
boxes for "Locked" and "Hidden", click "OK". Then click "Tools" on the menu
bar and select "Tools" then "Protection" then "Protect Sheet" and click "OK"
on the dialogue box that comes up. This should do it. Again let me know if
I am misunderstanding what you want.

Good Luck!

Brandt

> In Excel 2003 I am wanting to setup a formula where column C minus column B
> with the answer in column D.
[quoted text clipped - 4 lines]
> Thanks
> Stan W.

Reply to this Message

Stan W. - 10 Dec 2007 05:37 GMT

Hi Brandt,

I was trying to find some way of setting the formula and hiding it at the
same time. Your system of hiding the formula after will do exactly what I
want.

Thanks from a "mature age person".
Stan.

> Stan,
>
[quoted text clipped - 26 lines]
> > Thanks
> > Stan W.

Reply to this Message