Jan 20 2022 07:17 AM
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
Jan 20 2022 07:39 AM
Enter 0 in C1 and =B1 in A1
Jan 20 2022 08:02 AM
I need C1 to get to 0 by calculating and changing A1
Again this is a simplified example
Jan 20 2022 09:00 AM - edited Jan 20 2022 09:03 AM
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
Jan 20 2022 11:29 AM
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.