Forum Discussion
tlwarranties
Feb 26, 2022Copper Contributor
How do I create a formula in one sheet to + or - a number from a range of cells in another sheet?
I have a sheet (Sheet1) with a cell that has a # and I need that # to decrease or increase based on another sheet (Sheet2) range of cells.
- Feb 26, 2022
tlwarranties
Feb 26, 2022Copper Contributor
NikolinoDE I figured that part out, thanks. New question: how do I stop a value from repeating when there is nothing in one of the cells i'm using in the formula? Is there a way to make those either zeros or just blank?
SergeiBaklan
Feb 26, 2022Diamond Contributor
- tlwarrantiesFeb 26, 2022Copper ContributorPERFECT!!! thank you so much for your help!