# Excel Help

Closed
Mizan - Feb 21, 2012 at 08:19 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Feb 23, 2012 at 08:53 AM
Hello,

I'm trying to set a formula in below way, but it doesn't work, why?ould u plzz help?

=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"")))))))))))))))

## 2 replies

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
=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.

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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
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