Forum Discussion
Excel Formula
I have a spread sheet that tracks several aspects of certain students. I have been able to get it to do everything I want except this one thing. I want The entry in G2 to increment by 1 when there is a P or a T in L2. A working formula would be much appreciated.
Something like this? On G2:
=IF(OR(L2="P",L2="T"),5+1,5)
I am assuming 5 is your base normal entry in G2. This can be replaced by a formula or whatever might interest you to be placed on G2 in the event L2 does not contain a P or a T.
If you'd like to change existing value in one cell based on values in another cell(s) that's with VBA. If not, formula like Martin_Angosto suggested.
The base value will be 0 this is for attendance and G2 keeps track of days served P is present and T is tardy each will increment the days served A or blank will not.
