Including results of formula within concatenate function

[trandle]

Hi,

I have a table in a spreadsheet where the user enters a percentage into one of three categories to weight each so that the total of all categories equals 100%. All three categories must have an percentage entered.

Below the table, there is a cell that contains a constant text that explains the results of the above table AND needs to include the name or names of the categories with the highest percentage.

I believe using the concatenate function is the proper choice whereby the consant text may be concatenated with the results of a nested conditional formula that returns the appropriate category label depending upon which category in the table above has the highest percentage.

My problem seems to be that the concatenate formula is unable to combine the constant text with the results of a conditional formula nested within the formula.

My formula looks something like this =concatenate("The results of the above calculation indicate", =if(and(a1>a2,a1>a3),"red",""), "is the appropriate color."). Where a1 contains a percentage larger than either that contained within cells a2 or a3.

The formula returns an error. Any suggestions would be appreciated.

[martindwilson]

drop the = in front of =IF
or just use
="The results of the above calculation indicate "&IF(AND(A1>A2,A1>A3),"red","")&" is the appropriate color."