khanali007
New member
want some projects
khanali007 Intro
- Thread starter khanali007
- Start date
-
- Tags
- intro khanali007
khanali007
New member
excMarks Sheet
S# Name Test1 Test2 Test3 Total AVG Remarks
1 Zahid 35 24 24
2 Akber 56 53 45
3 Nida 12 13 23
4 Moon 56 76 34
5 Noor 26 75 87
6 Faisal 53 56 78
7 Benson 65 67 89
MAXIMUM? MINIMUM?
Fail
Good
HELP WITH INSTRUCTIONS
1 Calculate Total =SUM(FIRST RANGE:LAST RANGE)
2 Calculate AVERAGE =AVERAGE(FIRSTRANGE:LASTRANGE)
3 Calculate Maximum Value of Test1 and Minimum Value of Test2
=MAX(FIRSTRANGE:LASTRANGE)
=MIN(FIRSTRANGE:LASTRANGE)
4 Calculate Remarks using IF Condition
Parts of If Condition IF(Logic,"True Value","False Value")
Tips
Total > 100 , " Good"
Total < 100 , "Poor"
Solution
Type in Cell C10 =MAX(C3:C9)
Type in Cell D10 =MIN(D3
9)
Type in Cell G3 and Copy the formula =AVERAGE(C3:E3)
Type in Cell H3 and Copy the formula =IF(F3>100,"GOOD","POOR")
S# Name Test1 Test2 Test3 Total AVG Remarks
1 Zahid 35 24 24
2 Akber 56 53 45
3 Nida 12 13 23
4 Moon 56 76 34
5 Noor 26 75 87
6 Faisal 53 56 78
7 Benson 65 67 89
MAXIMUM? MINIMUM?
Fail
Good
HELP WITH INSTRUCTIONS
1 Calculate Total =SUM(FIRST RANGE:LAST RANGE)
2 Calculate AVERAGE =AVERAGE(FIRSTRANGE:LASTRANGE)
3 Calculate Maximum Value of Test1 and Minimum Value of Test2
=MAX(FIRSTRANGE:LASTRANGE)
=MIN(FIRSTRANGE:LASTRANGE)
4 Calculate Remarks using IF Condition
Parts of If Condition IF(Logic,"True Value","False Value")
Tips
Total > 100 , " Good"
Total < 100 , "Poor"
Solution
Type in Cell C10 =MAX(C3:C9)
Type in Cell D10 =MIN(D3
9) Type in Cell G3 and Copy the formula =AVERAGE(C3:E3)
Type in Cell H3 and Copy the formula =IF(F3>100,"GOOD","POOR")