Getting a #Value in my nested IF statement...

[djmousie]

I'm trying to create a nested if this is giving me a "#VALUE".

If you break up the IF statements, they work fine by themselves, but when combined, I get the #VALUE.

Any thoughts?

=IF(H65<F67,0),IF(H62<(H65-F67),(H65-F67),SUM(H60,H61,H62,H63))

 

[SkipVought]

Hi,

First CLOSE Parenthesis in the wrong place
[tt]
=IF(H65<F67,0,IF(H62<(H65-F67),(H65-F67),SUM(H60,H61,H62,H63)))
[/tt]


Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[djmousie]

Thanks for the quick reply, i knew it had something to do with my paranthesis.

 

[straybullet]

Try this:
=IF(H65<F67,0,IF(H62<(H65-F67),(H65-F67),SUM(H60:H63)))

The "value-if-false" portion now performs the 2nd "if".

Let them hate - so long as they fear... Lucius Accius

 

[AnotherHiggins]

Delete the [red]red[/red] ")" and add the [blue]blue[/blue] one.

=IF(H65<F67,0[red])[/red],IF(H62<(H65-F67),(H65-F67),SUM(H60,H61,H62,H63))[blue])[/blue]

John

Every generalization is false, including this one.

 

[AnotherHiggins]

Whoa, I'm just a *little* slow, huh? I tried to make it too pretty.

John

Every generalization is false, including this one.