K
Khalil Handal
I am working with 13 subjects, each subject has three marks (3 adjacent
cells, the third cell is the average of the previous 2) .
Cells AX15, AZ15, BB15 will have a formula to show the name of the subject
with the values of "F1" or "F2" or "F1, F2" depending on the marks in the
cells.
When AX15<>"" fill cell AZ15, if both cells (AX and AZ <>"" then fill in
cell BB15)
Example:
H15, I15, J15 has 3 marks (for English) J15 =average(H15:I15)
J14 has the 50% of the mark, I10 has the name of the subject
If J15<J14 then
if H15<J14 then AX15=I10 & "F1"
else if I15<J14 then AX15=I10 & "F2"
else if H15 and I15 < J14 then AX15=I10 & "F1" &
"F2"
else AX15=""
So, All Possible values for AX15 are:
" " or "English F1" or "English F2" or "English F1 , F2"
If the student has more than three subjects with average less then 50% then
AX15,AZ15, and BB15 will = "" and cell EX15="Fail"
This has to be done for therteen subjects for each student. Cells starts at
H15 until AT15.
Of course any formula has to be copyed down until line 64.
I hope I explaned myself clearly!
cells, the third cell is the average of the previous 2) .
Cells AX15, AZ15, BB15 will have a formula to show the name of the subject
with the values of "F1" or "F2" or "F1, F2" depending on the marks in the
cells.
When AX15<>"" fill cell AZ15, if both cells (AX and AZ <>"" then fill in
cell BB15)
Example:
H15, I15, J15 has 3 marks (for English) J15 =average(H15:I15)
J14 has the 50% of the mark, I10 has the name of the subject
If J15<J14 then
if H15<J14 then AX15=I10 & "F1"
else if I15<J14 then AX15=I10 & "F2"
else if H15 and I15 < J14 then AX15=I10 & "F1" &
"F2"
else AX15=""
So, All Possible values for AX15 are:
" " or "English F1" or "English F2" or "English F1 , F2"
If the student has more than three subjects with average less then 50% then
AX15,AZ15, and BB15 will = "" and cell EX15="Fail"
This has to be done for therteen subjects for each student. Cells starts at
H15 until AT15.
Of course any formula has to be copyed down until line 64.
I hope I explaned myself clearly!