How to put comments within formulas

I never suggested that Numbers should add a feature to do this, or that Excel could do it. And as I explicitly said in my first post, I am not looking for solutions based around comments or header names, so let's not continue those discussions.

What I'm looking for are clever workarounds to provide inline commenting within formulas.

I found three ways to do so.

Can anyone find any others?

As I said earlier, temporary tables are not practical or efficient, and I don't think this should be a feature.

I wasn't asking for well known, documented ways of solving the problem. Sometimes a good hack is faster and more efficient.

I just wanted to demonstrate how to manipulate Numbers into provide inline comments, and I was trying to get folks to think out of the box (well, in this case, within the cell's box).

Thanks for your input.

A slightly shorter alternative is to use IF(1,25,"May") but it's still clearer (visually and cognitively) to use IF(TRUE,25,"May").

Thanks, Jerry. I use comments in some cases but they aren't efficient in this situation because it is too much duplicated effort. It is one more place you have to go, you have to repeat your data entry, and you have to remember to keep it in sync when you change your formula.

Inline comments are much faster to type and to notice when reviewing and editing the formula.

Wayne, as I said twice previously, I am aware of using header cell names but that doesn't work since these values aren't referencing other cells. I only used May & June as an example.

Badunit, in my situation these formulas don't reference other cells or variables. I do that plenty often, but in this case these are many transient numbers that creating separate cells with headers would be too time consuming.

For example, I might be counting values for something I'm inventorying. An actual formula might look like:

= 10 + 25 + 22 + 5 + 15 + 5 + 2 + 160 + 5 + 5

That is the value for one location on one date; I have 12 locations, 100 dates with about 6 types of information to track, meaning 12 tables of 600 cells each already, 7200 cells total. I'm not going to also create 7200 separate tables with tens of thousands of cells to track each of those numbers separately; it's not that important and a big waste of time to do so.

But I do sometimes want to comment on discrepancies or unusual numbers. On the above, I might have written it as:

= 10 + 25 + 22 + 5 + 15 + 5 + 2 + IF(TRUE,160,"includes extra carryover from last week") + 5 + 5

Yes, comments are designed to do that. But they don't always make things easier: they are an extra place to enter information and look for it, and some people might miss it. The next day when someone updates the formula with changed values, they may not notice the comment, or they have to click back & forth to see what parts of the comment refer to what. If there are several commented values and they need to delete or change a certain one, it is easy at a glance to do so correctly.

I'm not saying there aren't other ways of doing this. I'm just saying in some limited circumstances inline comments could be time savers when you have a lot of data entry, and I was wondering if others had thought about solving the problem.