Cara Feliz Y Triste
How to create an average hanging happy or sad face in Excel? 3
To calculate the average of Incomcion Ouraching School 3rd grade student (with a formula) and if calculated, it is approved for those above 6 years and rejected for those under 6 years. Will go and give us the homework we will find. The formula for making faces happy or sad depends on whether it is accepted or rejected.
NS!
Suppose you have the following:
3
1
1
5
10
5 'Â' '' '' Average
6th
In cell A6, you must store the formula:
= Average (A2: A4)
Where the average value is to be calculated.
In the picture, we need to put the following formula in cell B6:
= Yes (A6> 6 pass, fail)
Finally, in cell C6, we enter the following formula:
= Yes (B6 = Approved J L)
Ara enters cell C6 at the door of the stretcher wings. Whether your face is happy or sad depends on whether you have been accepted or rejected. You can enlarge the body and paint the face to make it look better.
Esp help you, God bless you!
For example, I will give it to you when cell C3 has Approved or Denied formula.
If (c3 = problem, :), if (c3 = old, :(,)
XD
Thank you very much!
