Excel Help

Closed
Mizan - Feb 21, 2012 at 08:19 AM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- 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.
0
Thanks, Applied but still not working, I can't figuring out where is the prob...Please help!
0
I need to incorporate them in a cell with a condition, please help

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
0
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
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
0