SOLVED

New 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.

4 Replies

# Re: How do I create a formula in one sheet to + or - a number from a range of cells in another sheet

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.

Don't forget that not every Excel user has a clue about every job and what you see he can't see.

Welcome to your Excel discussion space!

Thank you for your understanding and patience

NikolinoDE

I know I don't know anything (Socrates)

# Re: How do I create a formula in one sheet to + or - a number from a range of cells in another sheet

@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?

best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: How do I create a formula in one sheet to + or - a number from a range of cells in another sheet

Perhaps

``=IF( B5="", "", C4-B5 )``

# Re: How do I create a formula in one sheet to + or - a number from a range of cells in another sheet

PERFECT!!! thank you so much for your help!