I am currenly playing a game of Ars Magica. I am using a spreadsheet to compute
the info for my character. I am having a probllem with the casting total for
spells related to a paticular character. The Formula is as follows :

=IF(H13="","--",IF(J13="",INDIRECT(H13),MIN(INDIRECT(H13),INDIRE CT(LEFT(J13,2)),INDIRECT(RIGHT(J13,2))))+IF(K13="" ,INDIRECT(I13),MIN(INDIRECT(I13),INDIRECT(LEFT(K13 ,2)),INDIRECT(RIGHT(K13,2))))+Sta+IF(N13="",0,$H$2 ))

I am trying to compute the casting total for the spells castable by this
character. The total for the casting total is the Technique + Form + Stanima.
This character has a additional abuility to double the lowest Technique or Form
and use that number for the casting total.

H13 is the Technique
I13 is the Form
J13 is the Requisite Technique
K13 is the Requisite Form


If you like to you can download the spreadsheet to look at

http://www.geocities.com/sanctumhr/SancMisc/magus.xls

At

http://www.geocities.com/sanctumhr/S.../sancmisc.html

The formula I am refering to is on the GRIMOIRE page in cell ( M13 ).

I am trying to compute the casting formula based on the Tech and For adjusted by
the requisited to double the lowest one and add that into the compution.. (add
the lowest applicable Art score twice)

The formula is for figuring the Diedne casting total (When you spend a fatigue
on casting a spontaneous spell, the lowest applicable art (Technique or Form)
is doubled)

Tech Cr(41) + Form Im(25) (Req Me 20) [ 41 + (20*2)] = 81

41 + min[25,20]*2 = 81


Any help would be appreciated..