Subtract value in a cell using another cells value

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3067153%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ESubtract%20value%20in%20a%20cell%20using%20another%20cells%20value%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3067153%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI'm%20trying%20to%20create%20a%20calculation%20for%20a%20%22what%20if%22%20scenerio%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ECell%20A1%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2099%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ECell%20B1%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%201%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ECell%20C1%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%2098%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EC1%20is%20calculating%2099-1%3D98%20(very%20simplified%20example)%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20want%20C1%20to%20equal%200%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ESo%20I'm%20trying%20to%20use%20a%20conditional%20statement%20that%20says%20%22%20IF%20C1%26gt%3B0%20then%20A1%3DA1-1%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20need%20to%20get%20C1%20to%200%20but%20am%20not%20sure%20what%20A1%20should%20be%2C%26nbsp%3B%20so%20I%20want%20it%20to%20calculate%20the%20value%20for%20me%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3067153%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

I'm trying to create a calculation for a "what if" scenerio

 

Cell A1       99

Cell B1          1

Cell C1       98

 

C1 is calculating 99-1=98 (very simplified example)

I want C1 to equal 0

So I'm trying to use a conditional statement that says " IF C1>0 then A1=A1-1

 

I need to get C1 to 0 but am not sure what A1 should be,  so I want it to calculate the value for me

 

6 Replies

@tkempke 

Enter 0 in C1 and =B1 in A1

I need C1 to get to 0 by calculating and changing A1

Again this is a simplified example

 

Screenshot.jpg

 

Trying to calculate the total dollars needed before expenses to have a zero dollar month.

I cant just back add because all the center costs change with a different top dollar amount

@Juliano-Petrukio 

@tkempke 

Try Data tab of the ribbon > What-if Analysis > Goal Seek...

In the dialog, set cell with loss to 0 by changing cell with dollar amount.

Then click OK.

Thats it!
Thanks