I'm not sure if anyone can help, but I'm trying to update my RMU character sheet (Excel) to autocalculate max pace from a character's total weight carried as a percentage of their own body weight. I've modded my own ideal values to be this (homebrew):
0 to 15% Weight Allowance = 4x max pace
16 to 30 WA = 3x max pace
31 to 60 WA = 2x max pace
61-90 WA = 1x max pace
91-151 WA = 0.5x max pace
So, on the character sheet, I am trying to figure out a formula to calculate max pace from weight allowance. Here's what I've entered:
=IF(‘Spells, Talents, Equipment’!N39:Q40<16, 4, IF(‘Spells, Talents, Equipment’!N39:Q40<31, 3, IF(‘Spells, Talents, Equipment’!N39:Q40<61, 2, IF(‘Spells, Talents, Equipment’!N39:Q40<90, 1, IF(‘Spells, Talents, Equipment’!N39:Q40>90, 0.5)))))
Whenever I do this, though, Excel tells me 'You've entered too many arguments for this function'. I've checked and I don't think I have too many brackets. Does anyone know what I'm doing wrong?