Too many arguments-VLOOKUP instead?

[Trina`]

help--I am trying to write this formula and the message I get is #valu
Too Many Arguments. How do I change it to work or should I us
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 thi
completely wrong. Any input would be greatly appreciated.

Trin

 

[ScottO]

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


|
| 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?action=getinfo&userid=24885
| View this thread: http://www.excelforum.com/showthread.php?threadid=384241
|

 

[Bob Phillips]

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)