=IFS(F25>I25,"F25-i25+J25",F25

Question

I am not sure what I am doing wrong, I want to find the sum of F25-I25 if it is greater than I25

Answer 1

The issue is that the IFS function is returning the text string "F25-i25+J25" instead of calculating the expression, and the logic does not match the stated requirement.

1. To return the calculated value of F25 - I25 + J25 when F25 > I25, and 0 otherwise, use an IF (or IFS) with the expression outside the quotes:

=IF(F25>I25, F25 - I25 + J25, 0)

2. If specifically wanting to use IFS for this simple case, it would be:

=IFS(F25>I25, F25 - I25 + J25, F25<=I25, 0)

Key points based on IFS syntax:

• Each logical_test must be followed by the corresponding value_if_true.
• Text values must be in quotes; formulas and cell references must not be in quotes.

---

References:

• IFS function
• IF function

Answer 2

Hi,

Try this formula

=SUMIF(F25:I25,">"&I25)

Hope this helps.