asked on

Excel -- texting formatting issue in formula

Experts:

I am using text formatting in a formula. Per attached XLS, the combination of cell referencing and text formatting results in some erroneous output.

That is, cell range H2:H4 has input values. Once I include these references, however, the cell output differs. The attached XLS provides more detail on this issue.

My question: Is there anything wrong with the **formatting** (text in formula) that causes the incorrect output? If so, how can this be fixed?

Thanks,
EEH
Formatting-text-in-formula.xlsx

ASKER CERTIFIED SOLUTION

Subodh Tiwari (Neeraj)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ExpExchHelp

ASKER

Perfect!!! Thank you so much for the prompt help... :)

Subodh Tiwari (Neeraj)

You're welcome. Glad I could help. :)

ExpExchHelp

ASKER

I'm now working on similar configurations. I already ran into a similar problem (again). I compared the two formulae (yours and mine). What exactly seemed to cause the problem?

EEH

Subodh Tiwari (Neeraj)

The Text Formula has two argument like =TEXT(value,format_text). In your previous formula the text function was not properly closed.

If you want to compare both the formulas and identify the changes between them, format two cells on your worksheet as Text and paste both the formulas in these two cells, that way you can easily identify the difference in them.

ExpExchHelp

ASKER

Copy that .... thank you sktneer.

Subodh Tiwari (Neeraj)

You're welcome.