Excel Help
Closed
Mizan
-
21 Feb 2012 à 08:19
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 23 Feb 2012 à 08:53
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 23 Feb 2012 à 08:53
Related:
- Excel Help
- Excel mod apk for pc - Download - Spreadsheets
- Vat calculation excel - Guide
- Kernel for excel repair - Download - Backup and recovery
- Arrow keys not working in excel - Guide
- Excel clear formatting - Guide
2 responses
Game Start Now
Posts
138
Registration date
Thursday 21 January 2010
Status
Member
Last seen
8 May 2019
7
21 Feb 2012 à 09:06
21 Feb 2012 à 09:06
=IF(J10="Safari 4.5",650,IF(J10="Safari 7",850,IF(J10="Safari 14",950,IF(J10="Safari 25",1150,IF(J10="Safari King",1250,IF(J10="Voyage 7",1250,IF(J10="Voyage 14",1450, IF(J10="Voyage 25",1850,IF(J10="Voyage King",2250,IF(J10="Expedition 7",2250,IF(J10="Expedition 14",2750,IF(J10="Expedition 25",4050,IF(J10="Expedition King",5250,IF(J10=" Prepaid 512 Kbps",0, IF(J10=" Prepaid 1 Mbps",0,"")))))))))))))))
Apply This.
Apply This.
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
23 Feb 2012 à 08:53
23 Feb 2012 à 08:53
Hi Mizan,
There's nothing wrong with your formula.
What do you want to accomplish / try to achieve?
Best regards,
Trowa
There's nothing wrong with your formula.
What do you want to accomplish / try to achieve?
Best regards,
Trowa
21 Feb 2012 à 09:28
21 Feb 2012 à 10:53
Type Value
A 100
B 200
C 300
D 400
E 500
F 600
G 700
H 800
I 900
J 1000
K 1100
L 1200
M 1300
N 1400
O 1500
P 1600
Q 1700
R 1800
S 1900
T 2000
U 2100
V 2200
W 2300
X 2400
Y 2500
Z 2600