Using first correct argument in if statement

[gss]

I have a fairly long if statement, goes something like (example)....

=if(D4<Ht,5,0) + if(D4<Gt,4,0) + if(D4<It,3,0)

Ht=5
Gt=4
It=10

If I input a value of '4' in D4, it'll output a value of 8. Is there any way that I can have excel output only the value of the first correct argument, so that the value that would be output in this case would be 5?

Thanks.

[DonkeyOte]

You would need to embed the IFs

=IF(D4<Gt,4,IF(D4<Ht,5,IF(D4<lt,3,0)))

alternatively

=LOOKUP(D4,{0,4,5},{4,5,3})

[gss]

If I embed the IF statements, I get an error saying I have too many nested if statements. So as far as I know, I have to do it this way.

As well, the lookup function won't work. It's too complicated for that.

[bruce2444]

Try this:

=IF(D4<Ht,5,IF(D4<Gt,4,IF(D4<It,3,0)))

Each IF statement requires a parameter, correct result, wrong result

[DonkeyOte]

Try this:

=IF(D4<Ht,5,IF(D4<Gt,4,IF(D4<It,3,0)))

Each IF statement requires a parameter, correct result, wrong result

Based on the example parameters I'm not sure that would work given you will never return 4 - ie if Gt < Ht then it follows that if D4 < Ht the Gt will never execute - you will always get the Ht result.

[martindwilson]

perhaps showing us your long if statement would help