Excel Help
[Closed]
Report
Mizan

TrowaD
TrowaD
 Posts
 2818
 Registration date
 Sunday September 12, 2010
 Status
 Moderator
 Last seen
 October 18, 2021
Related:
 Excel Help
 Transfer data from one excel worksheet to another automatically  HowTo  Excel
 How to change date format in excel to dd/mm/yyyy  HowTo  Excel
 Excel @ in formula ✓  Forum  Excel
 How to change author name in excel  HowTo  Excel
 Compare two worksheets and paste differences to another sheet  excel vba free download ✓  Forum  Excel
2 replies
Game Start Now
 Posts
 138
 Registration date
 Thursday January 21, 2010
 Status
 Member
 Last seen
 May 8, 2019
=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.
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