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

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Watch MrExcel Video

Forum statistics

Threads
1,114,072
Messages
5,545,825
Members
410,708
Latest member
Rumscheid
Top