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

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.