can you assign two formulas in one cell

T

tb

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.
 
B

Bernie Deitrick

For example,

=ROUNDUP(A1/A2,2)

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

HTH,
Bernie
MS Excel MVP
 
T

tb

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.
 
B

Bernie Deitrick

=ROUND(A1*A2,2)

with 41% in A1 and 6.30 in A2.

HTH,
Bernie
MS Excel MVP
 
Top