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,
User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives
Project - help calculate formula
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.
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.
3 posts
• Page 1 of 1
Project - help calculate formula
by sk3459 » Fri May 12, 2017 11:33 pm
- Attachments
-
- 2017-05-12_2200.png (4.06 KiB) Viewed 773 times
-
OpenOffice 4.1.3 on Windows 10
- sk3459
- Posts: 3
- Joined: Mon Nov 14, 2016 1:58 pm
Re: Project - help calculate formula
by 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.
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.
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: 3976
- Joined: Fri Jan 03, 2014 7:31 am
- Location: Sarnia, ON
Re: Project - help calculate formula
by 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 RC2 - Slackware 14.2 - 64 bit
David
OpenOffice 4.1.3 - Windows 7
OpenOffice 4.1.4 RC2 - Slackware 14.2 - 64 bit
-
robleyd - Volunteer
- Posts: 849
- Joined: Mon Aug 19, 2013 3:47 am
- Location: Murbko, Australia
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest
|
Forum powered by phpBB © phpBB Group
By any use of this Website, you agree to be bound by these Policies and Terms of Use |
Get OpenOffice
|