Too many arguments-VLOOKUP instead?
 

help--I am trying to write this formula and the message I get is #value
Too Many Arguments. How do I change it to work or should I use
VLOOKUP. I have never used that before.

=IF(D76="Xcaret",(59*G76)+(45*H76),0,IF(D76="C-Itza",(90*G76)+(0*H76),0,IF(D76="Xel-Ha",(70*G76)+(30*H76),0,IF(D76="Tulum/Xel-ha",(80*G76)+(40*H76),0))))

I'm not very good with the complicated formulas, so I may be doing this
completely wrong. Any input would be greatly appreciated.

Trina


--
Trina`
------------------------------------------------------------------------
Trina`'s Profile: http://www.excelforum.com/member.php...o&userid=24885
View this thread: http://www.excelforum.com/showthread...hreadid=384241

Try this instead (just removed a few extra " ,0 " between the IF nests ...
=IF(D76="Xcaret",(59*G76)+(45*H76),IF(D76="C-Itza",(90*G76)+(0*H76),IF(D76="Xel-Ha",(70*G76)+(30*H76
),IF(D76="Tulum/Xel-ha",(80*G76)+(40*H76),0))))
Rgds,
ScottO


"Trina`" wrote in message
...
|
| help--I am trying to write this formula and the message I get is #value
| Too Many Arguments. How do I change it to work or should I use
| VLOOKUP. I have never used that before.
|
|
=IF(D76="Xcaret",(59*G76)+(45*H76),0,IF(D76="C-Itza",(90*G76)+(0*H76),0,IF(D76="Xel-Ha",(70*G76)+(30
*H76),0,IF(D76="Tulum/Xel-ha",(80*G76)+(40*H76),0))))
|
| I'm not very good with the complicated formulas, so I may be doing this
| completely wrong. Any input would be greatly appreciated.
|
| Trina
|
|
| --
| Trina`
| ------------------------------------------------------------------------
| Trina`'s Profile: http://www.excelforum.com/member.php...o&userid=24885
| View this thread: http://www.excelforum.com/showthread...hreadid=384241
|

I would still use VLOOKUP myself, it aids maintenance.,

Put this table in say M1:O4

Xcaret 59 45
C-Itza 90 0
Xel-Ha 70 30
Tulum/Xel-ha 90 40


and then use

=IF(ISNA(MATCH(D76,M1:M4,0)),0,VLOOKUP(D76,M1:O4,2 ,FALSE)*G76+VLOOKUP(D76,M1
:O4,3,FALSE)*H76)

--
HTH

Bob Phillips

"ScottO" wrote in message
...
Try this instead (just removed a few extra " ,0 " between the IF nests ...

=IF(D76="Xcaret",(59*G76)+(45*H76),IF(D76="C-Itza",(90*G76)+(0*H76),IF(D76="
Xel-Ha",(70*G76)+(30*H76
),IF(D76="Tulum/Xel-ha",(80*G76)+(40*H76),0))))
Rgds,
ScottO


"Trina`" wrote in
message
...
|
| help--I am trying to write this formula and the message I get is #value
| Too Many Arguments. How do I change it to work or should I use
| VLOOKUP. I have never used that before.
|
|

=IF(D76="Xcaret",(59*G76)+(45*H76),0,IF(D76="C-Itza",(90*G76)+(0*H76),0,IF(D
76="Xel-Ha",(70*G76)+(30
*H76),0,IF(D76="Tulum/Xel-ha",(80*G76)+(40*H76),0))))
|
| I'm not very good with the complicated formulas, so I may be doing this
| completely wrong. Any input would be greatly appreciated.
|
| Trina
|
|
| --
| Trina`
| ------------------------------------------------------------------------
| Trina`'s Profile:
http://www.excelforum.com/member.php...o&userid=24885
| View this thread:
http://www.excelforum.com/showthread...hreadid=384241
|