View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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.