Subtopic	Posts		Updated
	Archive through April 15, 2011	25		04/15 05:12pm
	Archive through April 18, 2011	25		04/18 08:45pm
	Archive through August 19, 2012	25		08/19 05:16pm
	Archive through June 27, 2013	25		06/27 08:06pm
	Archive through February 07, 2022	25		02/11 04:51pm

Lar, something in duscus is not letting this format properly. I will send you the spreadsheet with the formulas.

By Lawrence Bergen (Lar) on Tuesday, February 08, 2022 - 12:40 am: Edit

Thanks Stewart, yes you are right when both cells are zero its incorrectly showing a -1 (well correct the way I have it, which is wrong for what I want.)

Because of your comments I was able to work it out...probably the hard way but here it is.

Cell = What # in cell represents
C7 = Alliance EW (zero or a positive number)
C8 = Alliance EW Shift (Formula)

C19 = Coalition EW (zero or a positive number)
C20 = Alliance EW Shift (formula)

C8 (formula) =IFS(C7*C7-C19-C7=-1,"-1",C7+C19=0,"0",C19-C7=5,"-2")

C19 (formula) =IFS(C19*C19-C7-C19=-1,"-1",C19+C7=0,"0",C7-C19=5,"-2")

This now seems to work AND include the rule exception. Like I said there might be a simpler version of this.

Thanks everyone! I Will take a look at your spreadsheet Mike...I also shared it with several people where I had their email.

By Alan De Salvio (Alandwork) on Tuesday, February 08, 2022 - 12:52 pm: Edit

I added the nested if statements to the spreadsheet you forwarded (which had no EW calculation in the fields) - the above post needs inequalities when comparing the 7 and 19 cells, as what is posted only works correctly for three discrete delta values, although I am not familiar with IFS.

By Lawrence Bergen (Lar) on Friday, February 11, 2022 - 02:28 pm: Edit

Thanks Alan that works. I have made a few more changes to the "totaling" cell and added a VBIR Shift generator.

I also realized I wasn't considering for the possibility of a fighting Retreat and set a condition if you answer Y for either attacker or defender then it ignores the BIR boxes/VBIR Shift and allows for putting the FR (Set values of 10 or 0) values in the "Other shift" box. Still accounting for EW shifts and additional combat roll.

By Alan De Salvio (Alandwork) on Friday, February 11, 2022 - 04:51 pm: Edit

fighting retreat makes my head hurt.

By Lawrence Bergen (Lar) on Friday, February 11, 2022 - 05:32 pm: Edit

Yeah. I have just been through all of this in a current game...its frustrating to step through.