An Interactive Use of the Lanchester Combat Model

Technical Comments on Excel

2. Only Whole Numbers? -- What To Do for Decimals

The Red and Blue Troop sizes are whole numbers, as troops must be represented as integers. Depending on the application, the user may wish to use decimals. Changing the format is quite simple.

Step 1: Begin by highlighting the cells for reformatting:

 

Step 2: Choose Format, Cells:

 

Step 3: Choose Number, and change Decimal Places to the desired number. The number shown is zero.