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
|