| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting a formula within a cell
=TEXT(A1+A2,"$.00")&" per 3 ounces "&TEXT(A3+A4,"$.00")&" per 4 ounces"
Vaya con Dios, Chuck, CABGx3 "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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting formula that uses VLookup, based on content of another cell | Excel Discussion (Misc queries) | |||
| Conditional Formatting if cell content is a formula | Excel Worksheet Functions | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
