Advanced - Named Cells: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 12: | Line 12: | ||
== The Boolean Named Cells == | == The Boolean Named Cells == | ||
These Named Cells simply return a TRUE/FALSE value, based on the status of the Character. | |||
{| border="1" width="80%" align="center" class="wikitable" style="text-align:left" cellpadding="1" cellspacing="0" | {| border="1" width="80%" align="center" class="wikitable" style="text-align:left" cellpadding="1" cellspacing="0" | ||
|+ '''''Table: The Boolean named cells''''' | |+ '''''Table: The Boolean named cells''''' | ||
| Line 19: | Line 19: | ||
|b_HeavyArmor || TRUE: if the Character is wearing a Heavy Armor | |b_HeavyArmor || TRUE: if the Character is wearing a Heavy Armor | ||
|- | |- | ||
|b_HeavyLoad|| TRUE: if the Load Class (from Gear) is Heavy | | style="background:#dddddd;" | b_HeavyLoad|| style="background:#dddddd;" |TRUE: if the Load Class (from Gear) is Heavy | ||
|- | |- | ||
|b_HoldingShield|| TRUE: if the Character is holding a Shield | |b_HoldingShield|| TRUE: if the Character is holding a Shield | ||
|- | |- | ||
|b_LightArmor|| TRUE: if the Character is wearing a Light armor, or no armor | |style="background:#dddddd;" |b_LightArmor||style="background:#dddddd;" | TRUE: if the Character is wearing a Light armor, or no armor | ||
|- | |- | ||
|b_LightLoad|| TRUE: if the Load Class (from Gear) is Light | |b_LightLoad|| TRUE: if the Load Class (from Gear) is Light | ||
|- | |- | ||
|b_MediumArmor|| TRUE: if the Character is wearing a Medium Armor | |style="background:#dddddd;" |b_MediumArmor||style="background:#dddddd;" | TRUE: if the Character is wearing a Medium Armor | ||
|- | |- | ||
|b_MediumLoad|| TRUE: if the Load Class (from Gear) is Medium | |b_MediumLoad|| TRUE: if the Load Class (from Gear) is Medium | ||
|- | |- | ||
|b_WearingArmor|| TRUE: if the Character is wearing any kind of Armor | |style="background:#dddddd;" |b_WearingArmor|| style="background:#dddddd;" |TRUE: if the Character is wearing any kind of Armor | ||
|} | |} | ||
Revision as of 13:05, 22 July 2006
The Sheet uses thousands of Named Cells to facilitate the creation of formulas. Althoug this page will not try to list all those named cells, the most useful ones are listed by category.
The Generic Named Cells
| Named Cells | Description |
|---|---|
| CR | CR is used to add a Carriage return to the text of a formula |
The Boolean Named Cells
These Named Cells simply return a TRUE/FALSE value, based on the status of the Character.
| Named Cells | Description |
|---|---|
| b_HeavyArmor | TRUE: if the Character is wearing a Heavy Armor |
| b_HeavyLoad | TRUE: if the Load Class (from Gear) is Heavy |
| b_HoldingShield | TRUE: if the Character is holding a Shield |
| b_LightArmor | TRUE: if the Character is wearing a Light armor, or no armor |
| b_LightLoad | TRUE: if the Load Class (from Gear) is Light |
| b_MediumArmor | TRUE: if the Character is wearing a Medium Armor |
| b_MediumLoad | TRUE: if the Load Class (from Gear) is Medium |
| b_WearingArmor | TRUE: if the Character is wearing any kind of Armor |