If you only calculate based on the previous values, you can directly use the if+and function to nest. Whether the previous column is a drop-down list or not. Just use the if function to judge whether the front is endorsement or calculation.
If you don't want to use functions, it is also recommended to use VBA events to solve this problem.