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

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,
Attachments
2017-05-12_2200.png
2017-05-12_2200.png (4.06 KiB) Viewed 489 times
numerology chart.png
OpenOffice 4.1.3 on Windows 10
sk3459
 
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.3 and LibreOffice 5.1.3.2 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.
RusselB
Volunteer
 
Posts: 3854
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.
Cheers
David
OpenOffice 4.1.3 - Windows 7
OpenOffice 4.1.4 - Slackware 14.2 - 64 bit
User avatar
robleyd
Volunteer
 
Posts: 727
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