ionstorm20
New Member
- Joined
- Apr 3, 2011
- Messages
- 14
Same Character Sheet, different problems...
I'm trying to take a characters initative and Attacks per Meele round and divide the number of attacks over the 15 seconds at set intervals.
The information is in the following cells
Attacks per round D6:D17
Initative E6:E17
Max Attacks per round D19 and uses the formula "=MAX(Attacks_Round)"
The formula I'm using to calculate the Attacks per round is
=IF(I$23<>"-",IF(($D$6/$D$19)*I23>COUNTIF($C$24:H24,"X"), "X","-"),"-")
The issue I'm having however is that the 1st action for every character is on action 1, but technically they would be going at second "7.5-ish" Any ideas?
I'm trying to take a characters initative and Attacks per Meele round and divide the number of attacks over the 15 seconds at set intervals.
The information is in the following cells
Attacks per round D6:D17
Initative E6:E17
Max Attacks per round D19 and uses the formula "=MAX(Attacks_Round)"
The formula I'm using to calculate the Attacks per round is
=IF(I$23<>"-",IF(($D$6/$D$19)*I23>COUNTIF($C$24:H24,"X"), "X","-"),"-")
The issue I'm having however is that the 1st action for every character is on action 1, but technically they would be going at second "7.5-ish" Any ideas?
