Excel Help
Closed
Mizan
-
Feb 21, 2012 at 08:19 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 23, 2012 at 08:53 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 23, 2012 at 08:53 AM
Related:
- Excel Help
- Excel marksheet - Guide
- Number to words in excel - Guide
- Excel free download - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
- Excel date format dd.mm.yyyy - Guide
2 responses
Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
Feb 21, 2012 at 09:06 AM
Feb 21, 2012 at 09:06 AM
=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 September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 23, 2012 at 08:53 AM
Feb 23, 2012 at 08:53 AM
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
Feb 21, 2012 at 09:28 AM
Feb 21, 2012 at 10:53 AM
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