Formulas
 

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

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.


--
excelrookie05
------------------------------------------------------------------------
excelrookie05's Profile: http://www.excelforum.com/member.php...o&userid=27204
View this thread: http://www.excelforum.com/showthread...hreadid=467490

how about an ' before the =

--
Don Guillett
SalesAid Software

"excelrookie05"
wrote in message
news:excelrookie05.1vcqug_1126706771.765@excelforu m-nospam.com...

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

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.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=467490

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

Thank you for the feedback ...


Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=467490

glad to help

--
Don Guillett
SalesAid Software

"excelrookie05"
wrote in message
news:excelrookie05.1vgdei_1126875995.387@excelforu m-nospam.com...

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