Feb 26 2022 07:37 AM
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 10:05 AM
With your permission, I recommend to provide more information.
If possible, add a file (without sensitive data) and use this file to describe your issue/project step by step, or add photos with the appropriate description.
Please, always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).
Don't forget that not every Excel user has a clue about every job and what you see he can't see.
In this link you will find some more information about it:
Welcome to your Excel discussion space!
Thank you for your understanding and patience
I know I don't know anything (Socrates)
Feb 26 2022 10:52 AM
@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?
Feb 26 2022 11:04 AM
SolutionFeb 26 2022 12:47 PM
Feb 26 2022 11:04 AM
Solution