IF statement returning value then text string

December 24, 2010 at 13:18:20
Specs: Windows 7
I'd like my Excel IF staement to return a calculation followed by some text. For instance, if the condition is TRUE it should perform and return the value of the calculation followed by the text string " to 1"

Below is my formula which works to return the value, but I get errors when trying to add the text portion:

I get errors when I try to add the text portion. The following formula which I have tried gives me an error:
=IF(D6="LONG",(F6-E6)/(E6-O6),(E6-F6)/(O6-E6)) " to 1"
I also get errors with:
=IF(D6="LONG",(F6-E6)/(E6-O6) " to 1",(E6-F6)/(O6-E6) " to 1")

How can I add the text " to 1" to the end of my returned value from the IF statement?

thank you,

See More: IF statement returning value then text string

Report •

December 24, 2010 at 14:57:54

=IF(D6="LONG",(F6-E6)/(E6-O6),(E6-F6)/(O6-E6)) & " to 1")


=IF(D6="LONG",(F6-E6)/(E6-O6) & " to 1",(E6-F6)/(O6-E6) & " to 1")



Report •
Related Solutions

Ask Question