if formula return
 

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?

if formula return
 

=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?

if formula return
 

Min will do what you want, as in:

=min(a2-a1,a3)

Regards,
Fred.

"Theresa" wrote in message
...
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?

if formula return
 

=IF(condition,MIN(A1-B1,C1),value_if_false)
--
David Biddulph

"Theresa" wrote in message
...
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?

if formula return
 

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?