Share via

IF Formula- Excel IF statement for numbers: greater than, less than, equal to

Anonymous
2021-03-23T15:48:37+00:00

How do I get my IF formula to work for the below situation: =IF, Field A is Greater than or equal to Field B, then average both fields, IF, Field A is Less than or equal to Field B, Use Field A?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2021-03-23T16:04:11+00:00

    Let's say we're talking about cells A2 and B2.

    =IF(A2>=B2,AVERAGE(A2:B2),A2)

    This can be filled or copied down if necessary.

    Was this answer helpful?

    0 comments