Formatting a formula within a cell
Col A Col B Col C
0.6 4 =TEXT(A1,"$0.00")&" per "&B1&" ounces"
result is
0.6 4 $0.60 per 4 ounces
--
Allllen
"Nancee Vee" wrote:
I am trying to use a formula and text within the same cell but I want the
value of the formula to have a currency format. Can this be done?
I have even tried to use a separate sell to calculate the formula to give me
a currency value and then input the value of the cell into the text/formula
cell and that doesn't work.
Example: I want the cell to read:
$.50 per 3 ounces $.60 per 4 ounces
by getting the currency amount from formulas
|