Apache OpenOffice Community Forum

Hello,

I want to be able to enter a word or words in a cell, then in the cell next to it have its numbers shown based on its numerology.

Every letter has a number e.g. a=1, b=2, c=3, etc.

(See attached).

E.g. London adds up to 29... 2 and 9 added together equals 11... however, double numbers shouldn't be broken in numerology, so it stays as an 11.

(See attached).

If you think you can help please get in touch.

Sincerely,

If you want to pay for this bit of advice, please make a donation to a local food bank.
This appears to be able to be done by using SUMPRODUCT with (or without) a MATCH. I think the formula would be simpler (and shorter) working with the MATCH function.
Regretfully I'm not at home, so I can't provide you with a working function, but this might be enough to enable you to work it out on your own.
If it is, great.... but either way I'll work on something when I get home.

This topic may also be helpful.