IF statement: 3 options

Hey all,

I want to create an IF statement that chooses between three values, (X, Y, Z). If, say, Y is the greatest of the three, I want the statement to show "Y is true", and do the same for X or Z.

How do I do this? Thanks!

@mike7952, that does show the maximum value of the three cells, but I want a statement to display based on that maximum.

Say if I have three ages: 10, 15, 20

I want an IF statement that if it is true, will say "Jenny is the oldest" for example.

Try this..... instead of "TRUE", put whatever you want....

=IF(A1=(MAX(A1:C1)),CONCATENATE(A1," ","TRUE"),IF(B1=(MAX(A1:C1)),CONCATENATE(B1," ","TRUE"),IF(C1=MAX(A1:C1),CONCATENATE(C1," ","true"),"")))

@JesusTello,

This is excellent, it returned the value I wanted. Only small thing is, it returned the actual value with the "true" statements I wrote in - is there a way to not have the actual number displaying, just the resulting "true" statement?

Yes but, it is always going to say just "true" column D. I don't get it...

Or you want the "true" in the column D E or F, depending in what column from A B or C the max value were?

Below is the screenshot of my spreadsheet. You'll see in B224 where my desired output is. There is the full number (52540...) that I do not want to display, followed by the "Concrete Breakout Controls", which is all I want.

excelforum.PNG

This is what you are asking for, but I'm sure is not what you want.

=IF(A1=(MAX(A1:C1)),CONCATENATE("Concrete Breakout Controls"),IF(B1=(MAX(A1:C1)),CONCATENATE("Concrete Breakout Controls"),IF(C1=MAX(A1:C1),CONCATENATE("Concrete Breakout Controls"),"")))

in which situations the "Concrete Breakout Controls" is going to change?

If you sent the file, maybe I can understand better...

@JesusTello,

Just fixed it; my error was including the cell address in my concatenated parenthesis. The spreadsheet is now working as I wanted it. Thank you for your help, I never knew about this command before. Cheers!