Hello to All!
I'm in need of solving this problem in a quick fashion. I'm not new to excel but I am very new to creating formulas. I need to create a formula for the 'average' attendance of my students at my company. I'm the coordinator at a large company for an English school we've installed and I have over 90 students at the time (which will grow and grow) and I am in charge of the attendance. I need to add value to the pound sign/letters and create a formula for the average.
I originally had the attendance as:
1=Attended
0=Did not attend and it's approved
#=Did not attend and it is not approved
###=Did not attend, to be determined if approved or not.
#=0
###=0
But then I was told that it would be easier to change the pound sign to a letter for formula changes, which for input purposes I prefer continuing to use the pound sign but you can't get everything you want
Now the attendance will be changed to:
1=Attended
0=Did not attend and it's approved
A=Did not attend and it is not approved
NA=Did not attend, to be determined if approved or not.
A=0
NA=0
Average Attendance
60% 1 1 A NA 1
40% 0 1 0 1 A
60% 1 # 1 1 ###
40% 0 1 # ### 1
Last note: I would like for all percentages 74% and below to be in RED.
Thank you very much in advance!
Bookmarks