Hey all. quick question from a not-so tech savvy person. I couldn't find this info on the help section of microsoft office, so I'm wondering if anyone knows if there is a way to format each row individually to display all information as far to the left as possible.
Another way around that is: can you have a formula in the same box as text?/ how? I'll keeping looking and if I find the answer I'll post here.
|
Hey all. quick question from a not-so tech savvy person. I couldn't find this info on the help section of microsoft office, so I'm wondering if anyone knows if there is a way to format each row individually to display all information as far to the left as possible.
Another way around that is: can you have a formula in the same box as text?/ how? I'll keeping looking and if I find the answer I'll post here.
I'm going to assume that you are using Excel? If so an easier way maybe than trying to put both text and a formula in the same cell is that you can put the formula in a column near the text (or not near that is up to you) and then hide that column. Would that work for what you need?
Most Exel and other spreadsheet character helpers do a bit of cheating by putting forumal calculations in hidden columns or on a second sheet(workbook) using cross workbook references.
Now there is is Function that you use to help you get text and data merged into one cell. CONCATENATE let's you combine strings (or text) into a single string (displayed in a single cell) this example is from my iWorks Numbers sheet on creating a city stat block (I'm still working on the sheet as a whole)
CONCATENATE ( Table 2::A6, IF(3 Corruption >= 0, " +", " "), 3 Corruption )
In my current test document I calculate the Corruption value on a different on Table 2 (Numbers allows multiple tables per sheet).
Table 2 cell A6 is the word Corruption.
The IF statement checks the actual value and if 0 or possative adds a + sign and a SPACE prior to it. Keep in mind if you want spaces in you CONCATENATEd (aka combined) result you have to make sure you add your own spaces. Excels help documetion on the function will help you. You'll note the second (false) result is just a space, as negative numbers already display with a - so I don't need to add it like the +.
Cell 3 Corruption is the would actually be called C6 (numbers can use replacement row and column names take from header row/columns), and is complext conditional (lots of IFs) related to totalling the Corruption based on which City traits are check in set of check boxes (whose base values are all stored on a 3rd table)
The output on sheet 1 (the stat block sheet) currently looks like this:
Name
N small
Corruption -2 Crime +1 Econonmy +1 Law -1 Lore +3 Society -2
Qualities
Danger +10
Demographics
Government Magical
I'm still working on how to CONCATENATE the checked Qualties and include the city size to various calculations.
I hope that gives you the location to begin looking for the answers you need.
I will assume that like me you are trying to create an output like the NPC stat blocks that appear in print and not something that looks like a Character PC sheet.