So you know what value you want in A1 but need to find out what value you need in B1? If that's so, try using Solver setting value of D1 to 0 and solving for B1. Would that work for you?