Adding a value to a specific cell

Discuss the spreadsheet application

Adding a value to a specific cell

Postby tkadz » Sat Feb 15, 2020 7:44 pm

Hi all, not sure where to post this as I'm new to open office and generally suck at spread sheets. So apologies if this is in the wrong place.

I have set up a spread sheet (image included) that has several sections/ tables, that shows a monetary value. I want to be able to put a tick in each cell, if i sell and item. And for the spread sheet to automatically tot up sales, depending on which item is sold.

For example. If i put a tick in the section marked stickers. I would like the total box to increase by 30p. But if I tick the poster box, the total will add on £10.

Does this makes sense? Is this even possible?

cheers in advance,

Kadz
Attachments
spreadsheet.PNG
Example image
Last edited by Hagar Delest on Sat Feb 15, 2020 11:38 pm, edited 2 times in total.
Reason: Move to Calc forum
open office 4.1.4 Windows 10
tkadz
 
Posts: 2
Joined: Sat Feb 15, 2020 7:32 pm

Re: Newb! Adding a value to a specific cell

Postby RusselB » Sat Feb 15, 2020 7:56 pm

Welcome to the Forums.
To start with, since you are using a spreadsheet, you should realize that the spreadsheet part of OpenOffice is called Calc, thus you should've posted in the Calc section.
I strongly suggest that you do not use a Check in the boxes, as putting numbers into them is a lot easier and gives you a lot more options later on.
For example, if you have 2 comics, instead of having to put in two checkmarks (which would limit you to 24 entries), you could just enter the number 2.. then you can easily get Calc to figure $2 * 2 items (I don't have the pound symbol for the currency you used available)... rather than have Calc count the number of checkmarks and then do the math.
It's a small difference to Calc, but for you to enter the information will be a lot easier.
OpenOffice 4.1.7 and LibreOffice 6.3.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.
User avatar
RusselB
Moderator
 
Posts: 6123
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Newb! Adding a value to a specific cell

Postby tkadz » Sat Feb 15, 2020 8:00 pm

Thank you,

im guessing going to the Calc part of this forum, i will be able to find the right tutorials to learn to do this?
open office 4.1.4 Windows 10
tkadz
 
Posts: 2
Joined: Sat Feb 15, 2020 7:32 pm

Re: Adding a value to a specific cell

Postby robleyd » Sun Feb 16, 2020 12:48 am

Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3467
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia


Return to Calc

Who is online

Users browsing this forum: No registered users and 12 guests