two numbers in one cell
 

I need to format one cell to have two formulas showing both answers as follows
" $25 / $35 "
I thoughthe formula (if simple) would look like this-
="$"(A3*A5) "/" "$"(A4*A5)

two numbers in one cell
 

="$"&A3*A5&" / $"&A4*A5

Vaya con Dios,
Chuck, CABGx3



"MikeC" wrote:

I need to format one cell to have two formulas showing both answers as follows
" $25 / $35 "
I thoughthe formula (if simple) would look like this-
="$"(A3*A5) "/" "$"(A4*A5)

two numbers in one cell
 

format may be a bad choice of words

="$"(A3*A5) "/" "$"(A4*A5)
=DOLLAR(A3*A5) & "/"&DOLLAR(A5*A7)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MikeC" wrote in message
...
I need to format one cell to have two formulas showing both answers as
follows
" $25 / $35 "
I thoughthe formula (if simple) would look like this-
="$"(A3*A5) "/" "$"(A4*A5)