Formulas

E

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 explai
what it does, but I don't want the equal sign to appear because it wil
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 t
have a value in there; only the formula itself must exist there.

Thanks all
 
E

excelrookie05

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

I inserted a comment field and I explained what the formula does an
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 t
my original question.

Thanks all
 
B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
formula for arriving net difference 0
Microsoft 365 Activations, Users or Devices? 0
Drop down list control value in vba 2
Delete a formula but leave the data. 2
Timesheet - Formula 4
dividing 0 by 0 in excel 2003 10
Possible Indirect query 1

Top