Can't write a needed formula in my checkbook sheet

Discuss the spreadsheet application

Can't write a needed formula in my checkbook sheet

Postby jhoward1950 » Sun Feb 23, 2020 1:38 pm

My example I have been trying to solve
f8 I enter Howard Pharmacy
g8 I want a formula in g8 that takes Howard Pharmacy and enters 2in the codes column
f7 I need a formula that takes code to and enters the classification THAT ARE ASSOCIATED WITH THE CODE

I am uncomfortable asking for help with this problem but me recovering from disc removal from my neck, heart problems, parkinsons and early stages of dementia I truly am blessed to have mind enough this little project.

If it is not an appropriate question for this formula, I sincerely apologize.

I am attaching a file that shows t he location of the sample I a m looking for a solution
Kindest regards
Jerry
Attachments
Sample spending spreadsheet.ods
(19.06 KiB) Downloaded 26 times
open Office 4.1.1 on Windows 10
jhoward1950
 
Posts: 3
Joined: Tue Jan 07, 2020 11:34 pm

Re: Can't write a needed formula in my checkbook sheet

Postby Villeroy » Sun Feb 23, 2020 3:39 pm

Open the attached database document and the input form therein.
The list of classes is stored in the "Categories" table.
The report shows monthly sums of amounts.
Attachments
CheckBook.odb
(23.04 KiB) Downloaded 21 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28536
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 18 guests