I need to deconstruct Excel formulas so that I don't have to put values in to see what the result is. I want to put in a result and get a values. I know this is difficult given with multiple variables the answer could be different. I'm looking for more of a theory or method to use to so that I don't have to hunt and peck for answers.
This is my simplified sheet.
A B C Formula for column C (Row 1) 25 10 (=IF(B1<15,5,10)) (Row 2) 15 22 (=ROUND((AVERAGE(B1:B3)),0)) (Row 3) 25 18 (=ROUND(((B3*5)/7),0)) Total 50 (=SUM(C1:C3))
For example, I want to come out with a total of 48. How would I go about working backwards so I didn't have to put a different number in column B to try and get the answer I am looking for, in this case, 48?