Share via

In If Formula want same response from different cell

Anonymous
2025-01-24T05:34:32+00:00

In IF formula i want to take two differen data from different cell but in response want to same response for example i sending the formula-------=IFERROR(IF(G16+H16<50,"Complies",IF(G16+H16<=75,"Alert",IF(G16+H16>75,"Action",IF(I16+J16<140,"Complies",IF(16+J16<200,"Alert",IF(16+J16>=200,"Action")))),"NA")

Here 4 type of response required (Complie,Alert,Action,NA) from 2 and 2 different cell.

Microsoft 365 and Office | Excel | For education | Other

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

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-01-24T13:03:58+00:00

    Could you share a screenshot of your data and show expected result? Then I can give formula suggestions on it.

    0 comments
  2. Rich~M 20,355 Reputation points Volunteer Moderator
    2025-01-24T16:50:49+00:00

    I'm not sure what your expected result is from the formula. It does have one serious issue. The imbedded IF functions will stop when a TRUE result is reached. In the case of your formula, that is the third condition. If the first condition is met, you will get "Complies". If it is not and it goes on to the next conditions, every possible combination is met in condition 2, <=75 or condition 3, >75. The rest of the formula will never be evaluated because a TRUE result will have already occurred.

    The second part of the formula is actually a totally different set of conditions that would result in a totally different result. This would have to be entered in another cell or else concatenated if you want to see both results in the same cell.

    0 comments
  3. Anonymous
    2025-01-25T10:17:38+00:00

    Please see the screen short

    0 comments
  4. Rich~M 20,355 Reputation points Volunteer Moderator
    2025-01-25T22:22:00+00:00

    This is still not enough information to evaluate the formula. You did not show what columns or rows the data referred to in the formula is in. Also, the desired result and its location is unclear. Are you looking for one result that is based on two different criteria, G16+H16 and I16+J16, so that to get a "Complies" both sets of criteria must be met or are you looking for two separate results where one could be "Complies" and the other might not.

    Without knowing what columns of data your formula is actually referring to it is impossible to come up with any suggestions. Please fill in the missing information and we will be glad to assist you.

    0 comments
  5. Anonymous
    2025-01-27T07:43:07+00:00

    Yes sir you are saying right... I think it is impossible in a cell Two different set of data can not respond desired outputs

    it is must i choose another one cell for 2nd set of Data...

    so i did it.

    Thanks very much... Rich-M

    I can send file if you like... on your email address. i you like to share.. My Email address is

    ******@gmail.com

    0 comments