How can I get Excel to add 1 to a specific cell when a specific value is returned elsewhere?

Answer 1

I would use an IF statement

=if( [cell] = [whatever you're testing for], [cell] + 1, [whatever you want it to do when you fail] )