| 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 |
| 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 | |||
Threaded Mode
