View Single Post
  #1   Report Post  
Trina`
 
Posts: n/a
Default 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