Need Pages Formula to subtract 1 ( in one cell ) as 35 from larger number in another cell.

I need a formula to Subtract "35" from a large number (5,915) for every "1" added to a column of cells that all contain 0 (zeros) presently. So the large amount being 5,915, if I add a "1" to either of the cells that contain zero presently then that cell will have a "1" instead of a "0" with the large number subtracting "35".

So if I add a 1 to one of the cells the number 5,915 will subtract 35 and now show 5,880. If I add 2, the large number will subtract 70 (35x2).

Make sense? See image.

Posted on Aug 16, 2023 2:15 PM

Reply
1 reply

Need Pages Formula to subtract 1 ( in one cell ) as 35 from larger number in another cell.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.