"IF" Formula help

[SaraQuinn]

Hello, I am trying to build a formula that will will be the following results:

I need in column D the result of A + B - C if the amount is less than column C
If the sum of A + B - C is higher than C then I need as a result the sum of A + B - C

So far I get zero using the following formula

=IF(A2+B2-C2>C2,A2+B2-C2,0)

Thank you in advance

 

[Candyman8019]

try =A2+B2-C2
From your description, if the result is > or < C, you're looking for the same calculation.

 

[SaraQuinn]

try =A2+B2-C2
From your description, if the result is > or < C, you're looking for the same calculation.

 

[Candyman8019]

If the result is negative then what are you expecting to see?

 

[SaraQuinn]

If the result is negative then what are you expecting to see?

I added that to my notes and description. Not sure how else explain the result I need.

 

[Candyman8019]

Your description isn't clear as to what you're looking for...if your Dental plus Vision costs are greater than your remaining benefit then it should be zero? else display remaining benefit?

Try this:
=IF(A2+B2-C2<0,0,A2+B2-C2)

 

[Fluff]

Another possible option

=MAX(A2+B2-C2,0)

 

[SaraQuinn]

Another possible option

=MAX(A2+B2-C2,0)

PERFECTION! thank you so much!
I never used MAX before.

 

[Fluff]

Glad we could help & thanks for the feedback.