Is there an Excel formula that I can paste into a spreadsheet that will spit out every combination of answers for X and Y when a value is given for Z and the question mark in the example formula x+(y*?)=Z that I don't know how to set up to do what I need it to do in Excel?
I'm looking for a formula in an Excel sheet in which the value for Z and the value multiplied against Y will be entered into the formula so that the Excel spreadsheet only has to generate every combination for X & Y to make the formula correct. In other words, the formula's task in the spreadsheet is to determine every combination for X & Y in which X plus (Y multiplied by the value I chose in the formula) equals the value I chose in the formula for Z.
The value I will be using for Z will range from 4000 to 7000. The value for ? will be a decimal with up to nine digits to the right of the decimal like 1.014561667
I only need to see how this can work for x+(y*1.014561667)=6000 and can use that formula or spreadsheet for the other scenarios I want
If there is a more clumsy way of accomplishing this like filling the spreadsheet with 4000 to 7000 answers, I'm ok with it and can search for the exact or closest X & Y values that are generated for the Z value that I chose.
This seems simple and I know how to use Excel, but can't seem to figure this one out.
I'm looking for a formula in an Excel sheet in which the value for Z and the value multiplied against Y will be entered into the formula so that the Excel spreadsheet only has to generate every combination for X & Y to make the formula correct. In other words, the formula's task in the spreadsheet is to determine every combination for X & Y in which X plus (Y multiplied by the value I chose in the formula) equals the value I chose in the formula for Z.
The value I will be using for Z will range from 4000 to 7000. The value for ? will be a decimal with up to nine digits to the right of the decimal like 1.014561667
I only need to see how this can work for x+(y*1.014561667)=6000 and can use that formula or spreadsheet for the other scenarios I want
If there is a more clumsy way of accomplishing this like filling the spreadsheet with 4000 to 7000 answers, I'm ok with it and can search for the exact or closest X & Y values that are generated for the Z value that I chose.
This seems simple and I know how to use Excel, but can't seem to figure this one out.