Combining Formulas

[Mike]

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

 

[JohnI in Brisbane]

Mike,

Is this what you're after?

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

JohnI

 

[Mike]

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

Mike