LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 01-29-2013, 01:46 AM   #1
faizlo
Member
 
Registered: Sep 2008
Location: USA
Distribution: Linux Mint Qiana
Posts: 190

Rep: Reputation: Disabled
OpenOffice Calc formula needed


Hi all,

I am sorry for my naive question but I really need help.
I have a spreadsheet which has 3 sheets in it.
This is a spreadsheet for students grades. the second sheet is for students attendance, which I want to link to their grades in the first sheet.
What I want is this:
Since all of the 3 sheets have the same set of names, then if a student gets a grade (greater than 0) on the first sheet, a letter "S" is to be shown in the corresponding cell in the second sheet.


How may I do this?

Thank you in advance,

~faizlo

Last edited by faizlo; 01-29-2013 at 01:49 AM.
 
Old 01-29-2013, 08:08 PM   #2
flshope
Member
 
Registered: Jul 2009
Location: Murfreesboro TN (United States)
Distribution: Ubuntu 16.04.3 and 14.04.5, Debian 8.9 and 9.2
Posts: 131
Blog Entries: 36

Rep: Reputation: 26
I have Libre Office rather than Open Office, but I think they are very similar. I found the following worked:

Assume you have Sheet1 and Sheet2.
Assume cell A1 in Sheet1 contains the numerical grade.
Sheet2 is where you want to display an "S" if the numerical grade > 0.

In Sheet1 cell A1 enter the numerical grade.
In Sheet2 cell A1 enter the formula: =Sheet1.A1
In Sheet2 cell B1 enter the formula: =if(A1>0;"S";" ")

If you don't want the numerical grade to appear on Sheet2, you can hide column A (select column A, then menu format/column/hide).

This is a bit clumsy. What I tried first was

In Sheet2 cell A1 enter the formula: =if(Sheet1.A1>0;"S";" ")

But it didn't work. Apparently the if function can't access cells in another sheet.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Formula Locking In LibreOffice Calc cin_ Linux - Software 2 11-19-2012 06:12 AM
Help Please - Open Office CALC Formula's SangrelX Linux - Software 1 06-23-2009 10:42 PM
OpenOffice.org Calc formula to check if day is last day of the month win32sux Linux - Software 1 01-19-2009 01:38 PM
elapsed time formula for open office calc philosophe Linux - Software 1 03-30-2005 06:32 AM
OpenOffice Calc formula question Bigun Linux - Software 2 08-16-2004 04:07 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 02:03 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration