TEXT for a percentage in a sentence
The same problem as DOLLAR, for any format: TEXT takes a format code.
Task:
The board summary needs a line per division such as Margin: 23.5%. Build it in C2:C5 from the margin in B, which is stored as a decimal.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of DOLLAR
0/3The same formula in the other shapes it takes at work.
- DOLLAR Function
Turning a number into the text you can drop into a sentence.
CoreIntermediate - DOLLAR inside a sentence
Joining a number to text drops its formatting — DOLLAR puts it back.
Intermediate - TEXT for a percentage in a sentence
The same problem as DOLLAR, for any format: TEXT takes a format code.
Intermediate
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Division | Margin | Summary |
| 2 | Retail | 0.2345 | |
| 3 | Wholesale | 0.118 | |
| 4 | Online | 0.3071 | |
| 5 | Trade | 0.09 |
What this exercise teachesMay contain the answer
DOLLAR only knows one format. TEXT accepts the same codes as the Format Cells dialog, so percentages, dates and padded numbers can all be dropped into a sentence. The format code also rounds for display: 0.2345 reads as 23.5%.