Hello all, I am confused how to collate or tabulate the results in this data set. Any help would be appreciated. I think this can be accomplished by using a formula but every effort has failed. I have given up and am asking for help.
This is for a Roll Playing Game with Star Wars type firearms. The Damage gets smaller with Range, as does the Penetration. I am looking for a way to tabulate the data in table B:3 to D:31. Then reproduce it in F:20 to K:21. I highlighted the applicable data in red (column B) and Orange (column C and D).
To explain the data in depth, B:3 to D:31 is a formulated data set. F:21 is the Damage 5 and penetration 2, from ranges of 0-5m. G:21 is where the damage is 4, pen 2. at ranges of 5-165m. H:21 ranges or 165-275 dam 3, 2 pen. So on so forth... Once the Pen is equal to the Dam, Nil should be displayed.
Bookmarks