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