How do I do complex math formulas like the one here:
check the one with PRODUCT. I need to use for loop or there is another way.
From Level 1 to Level 140:
( 10* ( (Level- 1) + 1.55 ^ (Level-1) ) * (isBoss * 10) ) this should work.
From Level 141 to Level 500:
(10 * ( 139 + (1.55^139) ) * (1.145 ^ ( Level-140 ) ) * ( isBoss* 10) ) this should work also.
From Level 501 onwards:
i dont know what the II sign means... its product of the above and beneath number however dont know how is represented in C2. probably is ceil() system expression but im not sure.
edited : since the sign with double II is pi
(10*(139+(1.55^139))* (1.145^360)* (pi/(i=501^Level))*(1.14+0.005)*(pi/(i/500))* (isBoss * 10)) - im not sure this will work... but you can test it out.
edited again: (pi/(i/500)) i think should be calculated with atan(i/500)
In which II is the product symbol or pi in C2 and  are ceiling brackets.
Edited 5 or so:
continuing with my stupidity probably
Hero Cost Formula (cost of upgrading from "Level")
The cost to level up Cid-Summer Cid, the Helpful Adventurer from level 1 to 15 is:
floor((5 + Level) * 1.07^Level - 1)
The cost to level up Cid-Summer Cid, the Helpful Adventurer from level 16 is:
floor(20 * 1.07^Level - 1)
The cost to level up other hero by one is:
floor(BaseCost * 1.07^Level - 1)