no dear you answer is correct the output is 12 as per your formula
2008/11/14 jmholt <[EMAIL PROTECTED]>
>
> I'm trying to figure out nested IF statements. The statement below
> works fine except for the last argument:
>
> IF(C7<=542,11,IF(C7<=589,12,L16)).
>
> IF C7=540 then it returns 11.
>
>
I am not sure what the problem is. I am using excel 2003 and its working fine..
can you forward your workbook as attachment.
_
"There are known knowns. These are things we know that we know. There ar
use
=IF(C7>=589,"L",IF(C7>=542,12,11))
Thanks & Regards
Harish Upadhyay
On 11/14/08, jmholt <[EMAIL PROTECTED]> wrote:
>
>
> I'm trying to figure out nested IF statements. The statement below
> works fine except for the last argument:
>
> IF(C7<=542,11,IF(C7<=589,12,L16)).
>
> IF C7=540 then it
I tried your example and it worked as it should. If you have a large number
of nested If statements consider using the Select Case construct in VBA. I
created a function cmp() included in the attached workbook that uses Case
Select to to what you want.
On Fri, Nov 14, 2008 at 10:48 AM, jmholt <[
