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
|