Forum Discussion
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.
4 Replies
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)
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?
