can you assign two formulas in one cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to divide two numbers one from each different cell with the
answer going into another cell. I also want the answer rounded up each time
into a percent.
 
For example,

=ROUNDUP(A1/A2,2)

format the cell with this formula for percentage....

HTH,
Bernie
MS Excel MVP
 
Bernie,

How would I figure multiplication of two cells with rounding to the nearest
cent. for example 41% x $6.30 = $2.59. But I need that in a formula.
 
=ROUND(A1*A2,2)

with 41% in A1 and 6.30 in A2.

HTH,
Bernie
MS Excel MVP
 
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

Divide two cells and if the number is negative display is as zero 2
Help to calculate Drinking Fountains 2
VLOOKUP return cell location and hyperlink 0
Multiple formats in a single cell with multiple formulas 1
Two Calculations in one column 4
Formula for adding a cell in multiple workbooks 3
COUNTIFS ? 1
Formula Funtions 7

Back
Top