Formulas

[excelrookie05]

Is there any way to type a formula into a cell, but not make it active? I want to have the formula on the spreadsheet so that I can explain what it does, but I don't want the equal sign to appear because it will most certainly give me a value.

This formula will add all the sums of E4 through E10
=SUM(E4:E10)

Like I said though, I don't want the cell that this formulas is in to have a value in there; only the formula itself must exist there.

Thanks all.

[excelrookie05]

I believe I found an answer to my question ...

I inserted a comment field and I explained what the formula does and how they have to change the range of numbers to get a value.

That might work for now, but I'm still curious if there is an answer to my original question.

Thanks all.

[BenjieLop]

Try preceding your formula with an apostrophe when you enter it in the cell, e.g,

'=sum(E4:E10)


I hope this is what you are looking for.

Regards.

[Don Guillett]

how about an ' before the =

--
Don Guillett
SalesAid Software
[email protected]
"excelrookie05" <[email protected]>
wrote in message
news:[email protected]...
>
> Is there any way to type a formula into a cell, but not make it active?
> I want to have the formula on the spreadsheet so that I can explain
> what it does, but I don't want the equal sign to appear because it will
> most certainly give me a value.
>
> This formula will add all the sums of E4 through E10
> =SUM(E4:E10)
>
> Like I said though, I don't want the cell that this formulas is in to
> have a value in there; only the formula itself must exist there.
>
> Thanks all.
>
>
> --
> excelrookie05
> ------------------------------------------------------------------------
> excelrookie05's Profile:
http://www.excelforum.com/member.php...o&userid=27204
> View this thread: http://www.excelforum.com/showthread...hreadid=467490
>

[excelrookie05]

Yea ... It worked !!!

I appreciate the help BenjieLop and Don Guillett.

[BenjieLop]

Thank you for the feedback ...


Regards.

[Don Guillett]

glad to help

--
Don Guillett
SalesAid Software
[email protected]
"excelrookie05" <[email protected]>
wrote in message
news:[email protected]...
>
> Yea ... It worked !!!
>
> I appreciate the help BenjieLop and Don Guillett.
>
>
> --
> excelrookie05
> ------------------------------------------------------------------------
> excelrookie05's Profile:
http://www.excelforum.com/member.php...o&userid=27204
> View this thread: http://www.excelforum.com/showthread...hreadid=467490
>