New Contributor

# Subtract value in a cell using another cells value

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

# Re: Subtract value in a cell using another cells value

Enter 0 in C1 and =B1 in A1

# Re: Subtract value in a cell using another cells value

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

Again this is a simplified example

C1=A1-A1

# Re: Subtract value in a cell using another cells value

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

# Re: Subtract value in a cell using another cells value

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