So I am building a spread sheet to track attendance among a certain number of days for a long period of time. The tracker divides attendance by weeks and puts out a number each week for the number of times you attended, that's simple. What I currently have it do is add up the number, and if it is more than 2 make it 2, if it is less than 2 make it what it is, and if there is no record for that week make it blank. Formula:=IF((SUM(B21:D24)>2),2, If(Sum(B21:D24)=0, "", SUM(B21:D24))), All this information is spit out into Cell B22.
What I want it to do is if cell B22 is blank, but cell E22 has a number in it to make B22 a 0, but if B22 already has a number to leave that number in B22. Can someone figure out a formula to do that? I can't seem to get it. I hope this makes sense.
What I want it to do is if cell B22 is blank, but cell E22 has a number in it to make B22 a 0, but if B22 already has a number to leave that number in B22. Can someone figure out a formula to do that? I can't seem to get it. I hope this makes sense.