After copying a fomula in excel, I ended up with the proper formula, however,
it copied the value of the cell from which I have copied the fomula.

When I tried to create the formula instead of copying it, I ended up with
zaro.