Hi Again,

In the following table, the formula for C is =IF(B1>5.5,0,5.5-B1)
A B C
------------------------
1 6 1 4.5
2 9 0 5.5
3 11 6 0
4 7 7 0

In the next table, the formula for C is =IF(A1<5.5,A1-B1,0)
A B C
--------------------------
1 2 0 2
2 5 4 1
3 3 3 0

The data in A will always be larger or equal to B
I would like to combine both formulas....I think I need the AND or OR
function in the IF statement but don't know how to set it up.

Any help would be appreciated,

Mike

Mike,

Is this what you're after?

=IF(A2<5.5,A2-B2,IF(B2>5.5,0,5.5-B2))

JohnI

"Mike" <(E-Mail Removed)> wrote in message
news:%TTub.9863$0K4.1376@lakeread04...
> Hi Again,
>
> In the following table, the formula for C is =IF(B1>5.5,0,5.5-B1)
> A B C
> ------------------------
> 1 6 1 4.5
> 2 9 0 5.5
> 3 11 6 0
> 4 7 7 0
>
> In the next table, the formula for C is =IF(A1<5.5,A1-B1,0)
> A B C
> --------------------------
> 1 2 0 2
> 2 5 4 1
> 3 3 3 0
>
> The data in A will always be larger or equal to B
> I would like to combine both formulas....I think I need the AND or OR
> function in the IF statement but don't know how to set it up.
>

John,
That is exactly what I am looking for. Thank you for your help.

Mike
"JohnI in Brisbane" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Mike,
>
> Is this what you're after?
>
> =IF(A2<5.5,A2-B2,IF(B2>5.5,0,5.5-B2))
>
> JohnI
>
> "Mike" <(E-Mail Removed)> wrote in message
> news:%TTub.9863$0K4.1376@lakeread04...
> > Hi Again,
> >
> > In the following table, the formula for C is =IF(B1>5.5,0,5.5-B1)
> > A B C
> > ------------------------
> > 1 6 1 4.5
> > 2 9 0 5.5
> > 3 11 6 0
> > 4 7 7 0
> >
> > In the next table, the formula for C is =IF(A1<5.5,A1-B1,0)
> > A B C
> > --------------------------
> > 1 2 0 2
> > 2 5 4 1
> > 3 3 3 0
> >
> > The data in A will always be larger or equal to B
> > I would like to combine both formulas....I think I need the AND or OR
> > function in the IF statement but don't know how to set it up.
> >
>
>