CODEWITHSUNDEEP
excelfunction
Royal
Royal

Reputation: 21

How do I return multiple values from three cells into one cell in Excel? I need to return a value

I have 3 cells in one worksheet and I want these cells to be returned into one cell in another sheet. If the value in a cell is an empty circle Empty circle in first column then "Dip not aligned" will be returned else "Dip aligned will be returned. Below is my logic for trying to return the 3 values in one cell, Excel gives me an error saying too many arguments.

=IF( Worksheet1!P8 = "○", "DP Not Aligned", "DP Aligned", IF( Worksheet1!Q8 
"○", "DITP Not Aligned", "DITP Aligned" ), IF( Worksheet1!R8 = "○", "DIIP 
Not Aligned", "DIIP Aligned" ))

Upvotes: 1

Views: 522

Answers (1)

girlvsdata
girlvsdata

Reputation: 1644

You could use an ampersand & to concatenate the results from your IF() statements, don't forget to use brackets to separate the IF() statements first.

Try this:

Example values in spreadsheet:

P8|Q8|R8
○ |○ |

Formula:

="DP " &(IF( Worksheet1!P8 = "○", "Not ", "")& "Aligned|" &"DITP "&( IF( Worksheet1!Q8 ="○", "Not ", "" ))&"Aligned|"&"DIIP "&( IF( Worksheet1!R8 = "○", "Not ", "" )))&"Aligned"

Example output:

DP Not Aligned|DITP Not Aligned|DIIP Aligned

*(Edited for more condensed, clearer code suggested by @Jeeped in comments)

My original formula:

=(IF( P8 = "○", "DP Not Aligned", "DP Aligned")& "|" &( IF( Q8 ="○", "DITP Not Aligned", "DITP Aligned" ))&"|"&( IF( R8 = "○", "DIIP Not Aligned", "DIIP Aligned" )))

Upvotes: 1

Related Questions