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

Paspalas, Jeanni 20 Reputation points
2026-06-18T17:02:29.7633333+00:00

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

Microsoft 365 and Office | Excel | For business | Windows
0 comments
Answer accepted by question author

AI answer

2026-06-18T17:02:48.7966667+00:00

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)
  1. 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:

AI-generated content may be incorrect. Read our transparency notes for more information.

Was this answer helpful?

1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 102.4K Reputation points Volunteer Moderator
    2026-06-18T22:56:17.69+00:00

    Hi,

    Try this formula

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

    Hope this helps.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.