Cannot get isna to work in formula

[Plantation]

Hello:

Having a problem to figure out why my formula won't work if I add ISNA into formula. The formula works good without the ISNA but when I add into the formula I get the following statement. "You've entered too many arguments for this function" and it highlights the 24 where I have ,$M40*45*24

Am I adding into the wrong part of the formula?? Can I even use the ISNA in this formula?

Here is the complete formula

=IF($E40="CONTRACT",0,IF($G40=$A$9,$K$9,IF($G40=$A$12,$K$12,IF(ISNA(VLOOKUP($G40,$A$8:$E$36,5,FALSE)=0,$M40*45*24,VLOOKUP($G40,$A$8:$E$36,5,FALSE)),"",VLOOKUP($G40,$A$8:$E$36,5,FALSE)=0,$M40*45*24,VLOOKUP($G40,$A$8:$E$36,5,FALSE))

Thank you for any help or suggestions you can pass on.

[sandy666]

Post formula before (without ISNA() )

[Tony Valko]

Can't tell what you're wanting the VLOOKUP to do. You repeated it 4 times.

The problem is that you don't have a closing ) for the ISNA function.

The typical use is:

IF(ISNA(VLOOKUP(...)), do something, do something else)

Meaning, If the VLOOKUP returns an #N/A error do something. If the VLOOKUP doesn't return the #N/A error then do something else.

Maybe you should explain in words what should happen.

[Plantation]

Hello again:
Here is a test page I've been working on with this formula. This is the original formula before I tried added the ISNA.(See column Q. Example Q40) =IF($E40="CONTRACT",0,IF($G40=$A$9,$K$9,IF($G40=$A$12,$K$12,IF(VLOOKUP($G40,$A$8:$E$36,5,FALSE)=0,$M40*45*24,VLOOKUP($G40,$A$8:$E$36,5,FALSE)))))

As you can see I have a bunch of #N/A's. Thank you for any assistance that could be offered.

[zbor]

Check first is it blank:

Please Login or Register  to view this content.

[Jonmo1]

It seems to me you only get the #N/A because the cell in column G is blank.
Perhaps

=IF($E40="CONTRACT",0,IF($G40=$A$9,$K$9,IF($G40=$A$12,$K$12,IF($G40="","",IF(VLOOKUP($G40,$A$8:$E$36,5,FALSE)=0,$M40*45*24,VLOOKUP($G40,$A$8:$E$36,5,FALSE))))))

[sandy666]

try:

Please Login or Register  to view this content.

[Plantation]

Thank you everyone for your quick response. I tested them and it appears that =IFERROR(IF($E40="CONTRACT",0,IF($G40=$A$9,$K$9,IF($G40=$A$12,$K$12,IF(VLOOKUP($G40,$A$8:$E$36,5,FALSE)=0,$M40*45*24,VLOOKUP($G40,$A$8:$E$36,5,FALSE))))),"") from sandy666 works great.

[sandy666]

Glad to help.
Thanks for rep.