two numbers in one cell

  • Thread starter Thread starter MikeC
  • Start date Start date
M

MikeC

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)
 
format may be a bad choice of words
=DOLLAR(A3*A5) & "/"&DOLLAR(A5*A7)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining Text From Cells 3
how do I average cells 4
Conditional Printing 2
Lowest number above 0 3
Mandatory and optional formula 5
Highlight duplicate cells based on a selected cell 5
Formula Content linked to other cells formula Content 5
Identify Text on two cells 1

Back
Top