Adding descriptive text to formulas without interfering w/ calcula

  • Thread starter Thread starter MZ
  • Start date Start date
M

MZ

How would I add text descriptions within formulas that would remind me what
different portions of the formula are intended to perform?
 
In EXCEL 2007:-

- right click the cell

- Insert Comment

If my comments have helped please hit Yes.

Thanks.
 
If you meant WITHIN(!) the cell/formula itself - then try something like this:
In cell A8 type 3 and in cell B8 type 6.
In whatever cell type: ="The result of A8 multiplied by B8 is: "&A8*B8
Is this what you are after ?
Micky
 
You understood me correctly that I want to add the text within the formula.
Your solution worked partially; it allows for putting text at the beginning
of the formula (right after the = sign); I tried putting text both at the
beginning and in the middle of the formula, but it does not work completely;
based on your example, here is what I did:
=IF("The result of 3*6 is 18 "&L5*M5=20,"Ok",
"If not, then it is "&L5*N5)

L5 =5
M5 = 4
N5=2

Based on this, the formula should have returned "OK." instead, it returned
"If not, then it is 6"; I tried changing the numbers but the formula seems to
be stuck on returning the second option
Any suggestions?
Thank you
 
Back
Top