=IF(Sheet1!O3>=4*"r",Sheet1!M3+Sheet1!N3+0.57*Sheet1!O3+Sheet1!P3-0.5*INDEX(Sheet3!$A$4:$K$6,MATCH(Sheet1!E3,Sheet3!$A$4:$A$6,0),MATCH(Sheet1!F3,Sheet3!$A$4:$K$4,0))-2.57*Sheet1!F3+IF(Sheet1!O3>=400,2*Sheet1!F3,0),"invalid
C")
but of course "r" is text so 4*"r" is zero.
If the r is the r you had earlier,
=IF(Sheet1!O3>=4*INDEX(Sheet3!$A$4:$K$6,MATCH(Sheet1!E3,Sheet3!$A$4:$A$6,0),MATCH(Sheet1!F3,Sheet3!$A$4:$K$4,0)),Sheet1!M3+Sheet1!N3+0.57*Sheet1!O3+Sheet1!P3-0.5*INDEX(Sheet3!$A$4:$K$6,MATCH(Sheet1!E3,Sheet3!$A$4:$A$6,0),MATCH(Sheet1!F3,Sheet3!$A$4:$K$4,0))-2.57*Sheet1!F3+IF(Sheet1!O3>=400,2*Sheet1!F3,0),"invalid
C")
--
David Biddulph
"willemeulen" <willemeulen.3sh7y7.TakeThisOut@thecodecage.com> wrote in message
news:willemeulen.3sh7y7@thecodecage.com...
>
> Another IF challange.
>
> I have the following formula (shematic):
>
> A + B + 0,57C + D - 0,5r - 2,57d
>
> Got the formula working nicely, even with the follwing incorporated
>
> If C >= 400 add 2d
>
> This is what it looks like:
>
> =Sheet1!M3+Sheet1!N3+0.57*Sheet1!O3+Sheet1!P3-0.5*INDEX(Sheet3!$A$4:$K$6,MATCH(Sheet1!E3,Sheet3!$A$4:$A$6,0),MATCH(Sheet1!F3,Sheet3!$A$4:$K$4,0))-2.57*Sheet1!F3+IF(Sheet1!O3>=400,2*Sheet1!F3,0)
>
> Yeah! But I want to incorparate another IF or other solution for the
> following:
>
> Value C >= 4r
>
> IF(Sheet1!O3>=4*"r",value_if_true,"invalid C")
>
> How do I tell excel, when the If is valid to continue with the function
> above, when not true it will write invalid C (or whatever fits the
> cell)
>
> Thanks
>
>
> --
> willemeulen
>
> Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands)
> ------------------------------------------------------------------------
> willemeulen's Profile:
> http://www.thecodecage.com/forumz/member.php?userid=285
> View this thread: http://www.thecodecage.com/forumz/showthread.php?t=98322
>
Microsoft Office