• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

subtracting in excel

Net

Golden Member

everytime i enter a number in column a i want column b to subtract 1

A
2
3
4

B
1
2
3

=SUM(A2:A4000) - 1 // will only subtract 1 once.
 
Back
Top