Subtract value in a cell using another cells value

[tkempke]

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

[#2]

@tkempke 

Enter 0 in C1 and =B1 in A1

[#3]

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

Again this is a simplified example

[#4]

C1=A1-A1

[#5]

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 

[#6]

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

[#7]

Thats it!
Thanks