View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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)