Evolutions possible

[Willy]

I'm trying to come up with a function that gives the number of evolutions possible given certain parameters, this is where I am so far.

A: Evolutions possible
Z: Candy needed to evolve said pokémon
X: Candy I have
Y: Number of the specified pokémon I have.

So this is where I get stuck.
A = (Y - ROUNDDOWN(X/Z) + X)/(Z + 1)
Reasoning:
Number of Pokémons I have (each worth one candy if transfered), subtract how many times I can evolve using only candy,
then add the amount of candy I have, divided by the amount of candy needed to evolve plus one (since I need one pokémon to evolve).

I'm about 90% certain that I missed quite a few things along the way, that's why I'm asking someone smarter for guidance!

[TheEnglishGuy]

I quickly took a look at your request and quickly made this. It will be tricky to add it in excel, and I am not even sure if the formula works (haven't tried it yet). Going to bed now, I should be able to give you a working excel compatible formula tommorow.

IF ROUNDDOWN((Y + X) / Z) - (Y - ( ROUNDDOWN((Y + X) / Z) x Z) - X) <0 = A = ROUNDDOWN(Y + X) / Z)

IF ROUNDDOWN((Y + X) / Z) - (Y - ( ROUNDDOWN((Y + X) / Z) x Z) - X) >0 = A = ROUNDDOWN(Y + X) / Z) -1

[phantom325]

EDIT: ****ed math up nevermind