can you assign two formulas in one cell
=ROUND(A1*A2,2)
with 41% in A1 and 6.30 in A2.
HTH,
Bernie
MS Excel MVP
"tb" wrote in message
...
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.
"Bernie Deitrick" wrote:
For example,
=ROUNDUP(A1/A2,2)
format the cell with this formula for percentage....
HTH,
Bernie
MS Excel MVP
"tb" wrote in message
...
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.
|