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...
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.