| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can you assign two formulas in one cell
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can you assign two formulas in one cell
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can you assign two formulas in one cell
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying Cell Formulas | Excel Discussion (Misc queries) | |||
| assign formula to another cell | Excel Worksheet Functions | |||
| Ideas for simplifying cell formulas | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Hybrid Mode
