On Oblivion
Your base Magicka is determined by multiplying your Intelligence by 2, then adding in any Racial and Birthsign bonuses.
No Birthsigns give Intelligence boosts.
Increasing your Intelligence past 100 will continue to give you increased Magicka.
 On Morrowind
Affects your total Magicka and magic use. Governs the skills of Alchemy, Enchant, Conjuration, and Security.
Related ThreadsThe Limits of Intelligence - last post by @ Feb 1, 2010
Problem gaining intelligence bonus points - last post by @ May 29, 2007
0 Intelligence - last post by @ Aug 24, 2009
Question On Intelligence - last post by @ Jul 5, 2009
Raising Intelligence - last post by @ Dec 13, 2007