Sorry, I might have mis-read your request;
Fred may not have,,,,,,

"JMay" wrote:

=IF(A1-A2C1,A1-A2,C1)

should work

"Theresa" wrote:

hello, i need help with an IF formula. I want the 'true' return to be value
of one cell minus another but not greater than the value of another cell.
How would I phrase in my formula after my argument?