Attendance Calculation

dear all

Requirement
Suppose there are 10 students in a class.If all students were absent,I have to get "A" in the respective cells
against the roll no.

Example:If I put A1=a, then "A" should be displayed in cells B1to B5 .
How I can solve this using excel function

With out any other info, try: In A1: "a" then select cells B1:B5, ensure B1 is the active cell. Then enter =UPPER(A1) and CSE.

You could use this if statement in cells B1:B5. If you want cells B1:B5 to populate with something if A1 does not have "A" in it, then you can type something in the last set of quotation marks in the formula below.

Please Login or Register  to view this content.

dear sir,
What is CSE?. Actually what I need is, instead of entering the absentees no. of all the students(if all the students were absent) in the respective cell against the roll no.,I will be entering the absent notation"a" in a single cell, so the "a" will be displayed in all cells against the roll no.

Dear sir,
Thank u for your reply. As per your answer, I will get "A" in a single cell(B1),If I had given the formula like this, B1= if($A$1="A"," A "," ")Is there any function in excel, to get "A" in a range of cells( for Example B1:B5) at a time
OR I will be entering the notation"A" in a single cell, so the "A" will be displayed in a range of cells .

If you type the formula in my previous post in each cell from B1 to B5, cells B1 to B5 will show the letter A if cell A1 has an A.