Working with text in formulas
MathGrid allows you to combine text with calculations in your formulas, making it easy to add currency symbols, labels, or units to your numeric results. This enables you to create more informative and readable table cells in InDesign.
How to add text to formulas
- Place text inside double quotes: "Your text here"
- Use the + operator to combine text with cell references or calculations
- Text can be placed before, after, or between numeric values
Text placement examples
- Prefix (text before number):
- Currency symbol: "€" + T1A1
- Label: "Total: " + T1A1
- Period indicator: "Q1: " + T1A1
- Suffix (text after number):
- Currency symbol: T1A1 + " $"
- Units: T1A1 + " kg"
- Percentages: T1A1 + " %"
- Combined formulas:
- "Total: £" + (T1A1 + T1B1)
- "Q" + 1 + ": " + T1A1
- "From " + T1A1 + " to " + T1B1
Using currency symbols
- MathGrid provides special buttons for common currency symbols: €, $, £, ₿
- Click a currency button to insert the symbol (already in quotes) into your formula
- Example: "$" + (T1A1 * 1.08) to convert to dollars
- You can also manually type any currency symbol: "¥" + T1A1 for Japanese yen
Important notes
- Always use double quotes (") for text
- Always use the + operator to join text with numbers
- When combining text and numbers, + acts as a text concatenation operator
- For complex calculations, use parentheses: "Total: " + (T1A1 * T1B1)
- Thousand separators and decimal places will still be applied to the numeric portions of your results
MathGrid ©
MathGrid ©
