|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
1 |
City |
1990 |
2000 |
2010 |
2020 |
|
=B1 |
=C1 |
=D1 |
=E1 |
2 |
City A |
244 |
438 |
982 |
1,001 |
|
=IF(B2>800,IF(ISTEXT(A2),"",IF(A2>800,(B2-A2)/A2,(A2-800)/800)),"") |
=IF(C2>800,IF(ISTEXT(B2),"",IF(B2>800,(C2-B2)/B2,(B2-800)/800)),"") |
=IF(D2>800,IF(ISTEXT(C2),"",IF(C2>800,(D2-C2)/C2,(C2-800)/800)),"") |
=IF(E2>800,IF(ISTEXT(D2),"",IF(D2>800,(E2-D2)/D2,(D2-800)/800)),"") |
3 |
City B |
7,000 |
7,943 |
7,543 |
6,894 |
|
=IF(B3>800,IF(ISTEXT(A3),"",IF(A3>800,(B3-A3)/A3,(A3-800)/800)),"") |
=IF(C3>800,IF(ISTEXT(B3),"",IF(B3>800,(C3-B3)/B3,(B3-800)/800)),"") |
=IF(D3>800,IF(ISTEXT(C3),"",IF(C3>800,(D3-C3)/C3,(C3-800)/800)),"") |
=IF(E3>800,IF(ISTEXT(D3),"",IF(D3>800,(E3-D3)/D3,(D3-800)/800)),"") |
4 |
City C |
699 |
850 |
932 |
955 |
|
=IF(B4>800,IF(ISTEXT(A4),"",IF(A4>800,(B4-A4)/A4,(A4-800)/800)),"") |
=IF(C4>800,IF(ISTEXT(B4),"",IF(B4>800,(C4-B4)/B4,(B4-800)/800)),"") |
=IF(D4>800,IF(ISTEXT(C4),"",IF(C4>800,(D4-C4)/C4,(C4-800)/800)),"") |
=IF(E4>800,IF(ISTEXT(D4),"",IF(D4>800,(E4-D4)/D4,(D4-800)/800)),"") |
Bookmarks