more info

[Mike]

Sorry about that,

A1 will always be equal OR greater than B1.

Two examples:

# 1. =IF(A1<5.5,A1-B1,0)
# 2 =IF(B1>5.5,0,5.5-B1)


A B C

 

[Don Guillett]

Mike,
Please stay in the original thread so we will know what you are talking
about.

 

[Dan E]

Mike,

For your Example with A = 23 and B = 2
A is not less than 5.5 so #1 doesn't apply
B is not greater than 5.5 so #2 doesn't apply

How do you end up with any result?

Dan E

IF A1 < 5.5

 

[Mike]

Hi Again,
Sorry for the confusion....
In the following table, the formula in 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 in 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

Any help would be appreciated,

Mike

 

[Dan E]

Mike,

=IF(A1<5.5,A1-B1,IF(B1>5.5,0,5.5-B1))

Dan E