What appends if you use Celestial Transformation to bring out Agent of Force- Mars? Since Mars is unafected by magic cards...will it be destroyed at the end of the turn or will it stay?

If you Special Summon "The Agent of Force - Mars", its ATK will still be halved and it will be destroyed during the End Phase. It is affected because it was not yet on the field when "Celestial Transformation" resolved.

http://www.yugioh-card.com is another good friend...

"If you Special Summon "The Agent of Force - Mars", its ATK will still be halved and it will be destroyed during the End Phase. It is affected because it was not yet on the field when "Celestial Transformation" resolved."