A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Intro Text Amounts
This intro problem practices VALUE. VALUE converts a number stored as text into a numeric value. Update the output cells so each row converts the text amount in column C into a number in column D. The total row illustrates how SUM does not total the text amounts in column C because it doesn't recognize them as numeric values, but it does total the converted numbers in column D.
See Examples
Your solution should use cell references so it updates automatically if the input cells change values.
Need help with VALUE details and syntax? Review the VALUE function guide first.
A1 expected value: *
