Calculation in a single cell with text remarks

[blockrocker]

Hi!

I'm working on a food management system spreadsheet in excel.

I would like to have calories counted for a food recipe in just one cell.

The question is, that can I also add text tips to identify the numbers being calculated?

I would like my cell formula to look like this:

=tomatoes 200 + potatoes 150 + butter 300

resulting simply in the answer: 650

So I don't need the text hints visible in the answer, just in the formula.. Is that possible to do?

[NBVC]

To add "notes" in a formula, we can use the N() function... which returns a 0 for text strings, so, in effect, it ignores the text and allows you to put it in the formula itself.

e.g.

=N("tomatoes")+200 + N("potatoes")+ 150 + N("butter")+300

[blockrocker]

Cool!

Thank you very much NBVC!