PC vs MAC dynamic range not working

I will thank them in once this is properly done and I can post photos, but currently I've had a LOT of help making this dice rolling program, but it won't work on a mac.
This is the file. What won't work? I cannot change the "Weapon" in cell B5 on the first sheet.
https://www.dropbox.com/s/92gt887nic...0TACTICAL.xlsx
https://www.dropbox.com/s/avnei2k1mq...ER%20EASY.xlsx
These dice rolling programs are very similar, yet the same problem occurs. B5 cannot be changed on a MAC. Someone please help me understand why, or enable cell B5 to work.
I have a PC and I'm using my brothers laptop MAC with excel 2011 on both computers.
Will post more info if needed. Thank you


Here's the boys in action 3 weeks ago. They had to get from one side of the board to the other without being caught.
https://www.dropbox.com/s/44am1rhl0l...11649786_o.jpg
Me with the laptop!https://www.dropbox.com/s/xz3fwqun8j...28358334_o.jpg
And last week was a lot of bush whacking through the jungles past old Vietnam like statues. https://www.dropbox.com/s/0d4yfbusk2...10620153_o.jpg
They crossed paths with some VC, but gave them the slip and continued on towards their mission.
https://www.dropbox.com/s/sv37v7xc3g...23917912_o.jpg

well i replaced cell B5 with the info but it didn't seem to work, now i just have a lot of #VALUE! errors. Wish I was better with this.

I cry a sigh of relief. THANK YOU SO MUCH!

I'm really a noob with this, and I spent all my time making the scenery for the game. But now finally, I don't have to roll 30+ dice for a few VC with AK-47s. Thanks again.

whoops, hang on, still not working. argh.

Pistol, Submachine gun work, however when selecting Machine Gun or Rifle, my weapon selection becomes "DyWepList". But honestly, it's half way there already.

Yeah I'm not worried about them so much for now. Probably because they won't be used much.

But the rifles and machine guns are standard so its a bit weird why they won't work.

Once I could get the rifles and MG working I'd put in some grenade/knife stuff, but for now, a lot more guns will be fired than knives thrown.

ooooh, very nice. I like that.

I shall write up some knives and grenade launchers. The main reason why grenades and launchers aren't in it is because their damage is a certain circle size that I place on the table. I'll write some up though now, just gotta write up someones new character sheet first.

https://www.dropbox.com/s/2ns1j3eduq...evised%29.xlsx

It's almost there! Just now the list doesn't work properly with the new weapons I added. Large Blade, Small Blade, Standard Grenade and Grenade Launcher. I didn't make this whole spreadsheet (just entered all the weapon info, I'm a noob) so I don't really know how to fix the few things that are off. I believe since Knife Throwing, Grenade and Grenade Launcher are all new weapon types, they aren't being noticed. But I could be wrong.

Thank you very much. Now I'm just back to the original problem, being that only the Pistol, Sub machine gun and Knife throwing categories are working right now. Stumped. But now, I feel we're edging towards success.

Okay will have a look at all this in the morning on the laptop. Might have made it worse as it seems the 5% chance has made it so only dice numbers 5 or below are a hit, when in some cases the number needed for a "HIT" can be much higher. I didn't notice this at first, argh one step forward, two steps back lol.

Okay so I went through all my files, and basically forgot to update excel....silly me.

After the first update the excel sheet works fine.

Only slight problem now is that the 5% chance has buggered up the chance to hit tables.

=IF(E2="","",IF(E2<=(1+(B13="Yes")*4),"Hit","Miss")) is the formula. It was supposed to work in times where the chance to hit was very low.

Basically the game is setup so you have a "weapon skill" which is a number from 1-100. You simply roll under that number to hit the target, minus of course the modifiers for range and posture.

However sometimes the number needed to hit was in the negatives, which wouldn't work. The game has a 5% chance so no matter how low the number needed to hit, there is always a 5% chance to hit, or they are "firing blind" and have only a 1% chance to hit.

Basically meaning any dice roll of 5 or lower is a hit, unless I have selected "Firing blind" in which case only a 1 will be considered a hit.
This works fine, however it's made it so only a 5 or lower or a 1 or lower is a hit. all other numbers are considered to be "miss" which isn't correct.

Anyway my original problem is solved, so thank you!

https://www.dropbox.com/s/p1iuqu672d...%20Rev%29.xlsx Is the file I'm using.