Split from 7.5

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?
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Watch MrExcel Video

Forum statistics

Threads
1,109,456
Messages
5,528,864
Members
409,842
Latest member
mfernandezcean
Top