Need Cell Text in Place of a #

[hkydad]

I was wondering if anyone can telkl me how to formual a cell so that it appears as text in a different cell? For example:

Cell B1: 120,715.00
Cell K2: =B1 But I want K2 to say CM for Contribution Margin and not show the actual # from B1.

Thank you in advance.

 

[kweaver]

Your explanation is unclear to me. If K2 is equal to B1, now can it NOT show the result? If you simply want K2 to be the text "CM" then just type if there.

I think you need to show more examples and how you derive the answers.

 

[Tetra201]

@ hkydad: this is doable via custom-formatting cell K2 as "CM" -- but what's the purpose?

 

[hkydad]

Your explanation is unclear to me. If K2 is equal to B1, now can it NOT show the result? If you simply want K2 to be the text "CM" then just type if there.

I think you need to show more examples and how you derive the answers.

What I am looking at is trying to create a one-variable data table where the table headings are linked back to the assumptions but instead of having the assumption figure appear in the header, I want the header to reflect what the # is representing. For example, in the table to the far right, the CM & NetProfit headers are linked back to the CM Data - 17,500.00 & the NetProfit header is linked back to the Marginal Net Income data - $28,089.75. The headers should say CM & NetProfit. The one-variable data table was already formatted for this but I am wondering how to do this, so I know for future use. I hope this clarifies what I am looking for.