Eg: The total cars sold this month was (Cell A35) which is (Cell D4) % of our yearly total
O Ozinus Dec 25, 2008 #1 Eg: The total cars sold this month was (Cell A35) which is (Cell D4) % of our yearly total
T T. Valko Dec 25, 2008 #2 Try this (all on one line): ="The total cars sold this month was "&A35 &" which is "&D4&" % of our yearly total" Depending on the formats of the referenced cells, we might have to tweak it a bit. See how that works.
Try this (all on one line): ="The total cars sold this month was "&A35 &" which is "&D4&" % of our yearly total" Depending on the formats of the referenced cells, we might have to tweak it a bit. See how that works.
R Ron Rosenfeld Dec 25, 2008 #3 Eg: The total cars sold this month was (Cell A35) which is (Cell D4) % of our yearly total Click to expand... ="The total cars sold this month was " & A35 & " which is " & TEXT(D4, "0.0%") & " of our yearly total" --ron
Eg: The total cars sold this month was (Cell A35) which is (Cell D4) % of our yearly total Click to expand... ="The total cars sold this month was " & A35 & " which is " & TEXT(D4, "0.0%") & " of our yearly total" --ron
R Rick Rothstein Dec 25, 2008 #4 ="The total cars sold this month was "&A35&" which is "&D4& "% of our yearly total" The above formula should all be on one line.
="The total cars sold this month was "&A35&" which is "&D4& "% of our yearly total" The above formula should all be on one line.
