In If Formula want same response from different cell

Anonymous

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.

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.

7 answers

Rich~M 20,355 Reputation points Volunteer Moderator

2025-01-27T16:58:22+00:00

Just to clarify, a formula cannot give two results. However, it would be possible to have two results in a cell if you Concatenate two separate formulas to combine the results in a cell. In addition, you could add text into the resulting string if desired. Here is an example using your two criteria groups in separate formulas concatenated along with some text.

="Settle Plate: "&IFERROR(IF(G16+H16<50,"Complies",IF(G16+H16<=75,"Alert",IF(G16+H16>75,"Action"))),"N/A")&" / Air Sampling: "&IFERROR(IF(I16+J16<140,"Complies",IF(16+J16<200,"Alert",IF(16+J16>=200,"Action"))),"NA")

EDIT;

Just noticed that in your formula there seems to be an error in two of the cell references in the second part. The Alert and Action conditions refer to I6+J16. I believe from the pattern that those should both be I16 +J16.
Please sign in to rate this answer.

0 comments No comments

Anonymous

Mr. Rich-M

               Very thanks to you.... I am very glade... i was thinking that it was impossible but you did it.... and give another way of thinkin.... I am very thanksfull to you.....

May my Allah bless you with the wealth of faith.

Share via

In If Formula want same response from different cell

7 answers