I'm trying to add a complex formula into a starship construction spreadsheet, but the formula needed is currently beyond my excel-fu. Can anyone help? The rule is as follows:
Probes add to the ship's ORAT(offensive rating) as follows:
HULL DIVISOR
1-3 (Engines+6)*2.1
4-8 (Engines+6)*1.4
9-15 (Engines+6)*1.0
16-24 (Engines+6)*0.8
25+ (Engines+6)*0.7
In the spreadsheet, the hull value will be in cell AV8, and engine value in cell AV9.
Thanks for any help!