text and formula within the same cell
 

Hi. I want to include text and formula within the same cell in Excel.
Does anyone know how I can do it?

I am trying to acheive (A4*B7)membership+(C3*D10)journals so it
appears as a number (say 100) but anyone looking at the formula can see
what it relates to.

Can anyone help please?

Thanks

text and formula within the same cell
 

=a4*b7 +N("membership") + c3*d10 +N("Journals")
works with numbers.

And something like:

=A1 & " " & b1 & TEXT("this is a comment",";;;")
will work when you want to return Text.



Lucy wrote:

Hi. I want to include text and formula within the same cell in Excel.
Does anyone know how I can do it?

I am trying to acheive (A4*B7)membership+(C3*D10)journals so it
appears as a number (say 100) but anyone looking at the formula can see
what it relates to.

Can anyone help please?

Thanks

--

Dave Peterson

text and formula within the same cell
 

=A4*B7&" Membership "&C3*D10 &" Journals"

"Lucy" wrote:

Hi. I want to include text and formula within the same cell in Excel.
Does anyone know how I can do it?

I am trying to acheive (A4*B7)membership+(C3*D10)journals so it
appears as a number (say 100) but anyone looking at the formula can see
what it relates to.

Can anyone help please?

Thanks

text and formula within the same cell
 

Maybe this.......

=A4*B7&" Membership + "&C3*D10 &" Journals"

Vaya con Dios,
Chuck, CABGx3


"Lucy" wrote:

Hi. I want to include text and formula within the same cell in Excel.
Does anyone know how I can do it?

I am trying to acheive (A4*B7)membership+(C3*D10)journals so it
appears as a number (say 100) but anyone looking at the formula can see
what it relates to.

Can anyone help please?

Thanks

text and formula within the same cell
 

It would probably be better to use a standard formula like
=(A4*B7)+(C3*D10)
and then insert a comment to explain the formula (right click cell - insert
comment). I don't think you can add notes to a formula inside the formula.



"Lucy" wrote:

Hi. I want to include text and formula within the same cell in Excel.
Does anyone know how I can do it?

I am trying to acheive (A4*B7)membership+(C3*D10)journals so it
appears as a number (say 100) but anyone looking at the formula can see
what it relates to.

Can anyone help please?

Thanks

text and formula within the same cell
 

Sorry, I mis-read your post.....probably this will do as you wish.....

=(A4*B7)+(C3*D10)+N("Membership + Journals")


hth
Vaya con Dios,
Chuck, CABGx3



"CLR" wrote:

Maybe this.......

=A4*B7&" Membership + "&C3*D10 &" Journals"

Vaya con Dios,
Chuck, CABGx3


"Lucy" wrote:

Hi. I want to include text and formula within the same cell in Excel.
Does anyone know how I can do it?

I am trying to acheive (A4*B7)membership+(C3*D10)journals so it
appears as a number (say 100) but anyone looking at the formula can see
what it relates to.

Can anyone help please?

Thanks

text and formula within the same cell
 

Sloth

It is possible to add explanatory notes inside a formula.

Look at Dave P's post or see below...........

=a2*a1+n("my wage+bonus-4 weekly loan repayments")

The text after the n will show in the formula bar but not in the cell.


Gord Dibben MS Excel MVP


On Thu, 21 Sep 2006 07:18:03 -0700, Sloth
wrote:

It would probably be better to use a standard formula like
=(A4*B7)+(C3*D10)
and then insert a comment to explain the formula (right click cell - insert
comment). I don't think you can add notes to a formula inside the formula.



"Lucy" wrote:

Hi. I want to include text and formula within the same cell in Excel.
Does anyone know how I can do it?

I am trying to acheive (A4*B7)membership+(C3*D10)journals so it
appears as a number (say 100) but anyone looking at the formula can see
what it relates to.

Can anyone help please?

Thanks

text and formula within the same cell
 

Thank you to everyone who replied

Lucy

Gord Dibben wrote:
Sloth

It is possible to add explanatory notes inside a formula.

Look at Dave P's post or see below...........

=a2*a1+n("my wage+bonus-4 weekly loan repayments")

The text after the n will show in the formula bar but not in the cell.


Gord Dibben MS Excel MVP


On Thu, 21 Sep 2006 07:18:03 -0700, Sloth
wrote:

It would probably be better to use a standard formula like
=(A4*B7)+(C3*D10)
and then insert a comment to explain the formula (right click cell - insert
comment). I don't think you can add notes to a formula inside the formula.



"Lucy" wrote:

Hi. I want to include text and formula within the same cell in Excel.
Does anyone know how I can do it?

I am trying to acheive (A4*B7)membership+(C3*D10)journals so it
appears as a number (say 100) but anyone looking at the formula can see
what it relates to.

Can anyone help please?

Thanks