Latest LQ Deal: Linux Power User Bundle
Go Back > Forums > Linux Forums > Linux - Software
User Name
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.


  Search this Thread
Old 01-29-2013, 12:46 AM   #1
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,


Last edited by faizlo; 01-29-2013 at 12:49 AM.
Old 01-29-2013, 07:08 PM   #2
Registered: Jul 2009
Location: Murfreesboro TN (United States)
Distribution: Ubuntu 16.04.4 and 14.04.5, Debian 8.10 and 9.4
Posts: 137
Blog Entries: 36

Rep: Reputation: 27
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.


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 05:12 AM
Help Please - Open Office CALC Formula's SangrelX Linux - Software 1 06-23-2009 09:42 PM Calc formula to check if day is last day of the month win32sux Linux - Software 1 01-19-2009 12:38 PM
elapsed time formula for open office calc philosophe Linux - Software 1 03-30-2005 05:32 AM
OpenOffice Calc formula question Bigun Linux - Software 2 08-16-2004 03:07 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 04:19 AM.

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