Project - help calculate formula

Just a meeting place for professional offers & requests
Forum rules
Disclaimer: this section of the forum is just a meeting place for professional offers & requests. We do not and cannot insure the liability of the proposal made publicly in the forum or privately after contact has been made in the forum. Therefore, please take up the offers made here at your own risk.

Project - help calculate formula

Postby sk3459 » Fri May 12, 2017 11:33 pm


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.

2017-05-12_2200.png (4.06 KiB) Viewed 1857 times
numerology chart.png
OpenOffice 4.1.3 on Windows 10
Posts: 3
Joined: Mon Nov 14, 2016 1:58 pm

Re: Project - help calculate formula

Postby RusselB » Sat May 13, 2017 1:36 am

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.
OpenOffice 4.1.6 and LibreOffice on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
Posts: 5172
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Project - help calculate formula

Postby robleyd » Sat May 13, 2017 3:04 am

This topic may also be helpful.
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
Posts: 2809
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Return to Paid support

Who is online

Users browsing this forum: No registered users and 1 guest