Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 | |
#3
|
|||
|
|||
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 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
make a vlookup using a variable path | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions |