Formula calculation help

[francisobrien2011]

Hi,

I want help to create the following formula but I am sure how to do it.

A-B = X

If X is equal or less than fixed value in column C then change that value to the one found in column C. X could contain some negative values which I also need to set to the value in column C.

Any ideas,

Best,

Francis

 

[eibi]

Paste this in X1:

=IF(A1-B1<=C1,C1,A1-B1)

(see attached)

Does that solve it?

 

[francisobrien2011]

This works. Thank you so much for your help

Paste this in X1:

=IF(A1-B1<=C1,C1,A1-B1)

(see attached)

Does that solve it?

 

[John Jairo V]

Hi to all!

This also may work:
=MAX(C1,A1-B1)

Blessings!