Hi,

you need to rearrange the formula, if I did it correctly it is

Z=(Y/X-A)*X/(X-Y)


--
Thanks,
Shane Devenshire


"Simon Jowitt" wrote:

Hi, I have an equation in the following form: x = (y*(z+1))/(z+a) which I
have the values for x, y and a, but need to find a value for z. I can do this
one at a time using the SOLVER add-in - but is there another way around this?
or can you run multiple versions of solver e.g. to determine 100+ values of z
for 100+ different equations? even 20+ would do!