goal seek
A B C D E F G
249999999997 | 1 | 2 | 249999999995 | 499999.999995 | 499998 | 1.9999950000201352 |
---|---|---|---|---|---|---|
249999999997 | 2 | 3 | 249999999991 | 499999.999991 | 499998 | 1.9999909999896772 |
249999999997 | 3 | 4 | 249999999985 | 499999.999985 | 499998 | 1.999985000002198 |
249999999997 | 4 | 5 | 249999999977 | 499999.999977 | 499998 | 1.9999769999994896 |
249999999997 | 5 | 6 | 249999999967 | 499999.999967 | 499998 | 1.9999669999815524 |
249999999997 | 6 | 7 | 249999999955 | 499999.999955 | 499998 | 1.9999550000065938 |
249999999997 | 7 | 8 | 249999999941 | 499999.999941 | 499998 | 1.9999410000164062 |
249999999997 | 8 | 9 | 249999999925 | 499999.999925 | 499998 | 1.9999250000109896 |
249999999997 | 9 | 10 | 249999999907 | 499999.999907 | 499998 | 1.999906999990344 |
249999999997 | 10 | 11 | 249999999887 | 499999.999887 | 499998 | 1.9998870000126772 |
249999999997 | 11 | 12 | 249999999865 | 499999.999865 | 499998 | 1.9998650000197813 |
249999999997 | 12 | 13 | 249999999841 | 499999.999841 | 499998 | 1.9998410000116564 |
When column A = column D + column E and E is an integer, the goal is reached. Do you have a function similar to isinteger? I could count up column B until Col G equals 1; but that might take 500,000 cycles and would be difficult to find.
Can the goal seek tool be restricted to integer inputs?