View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
howdylee howdylee is offline
external usenet poster
 
Posts: 1
Default round a formula's result

in a single cell, i need a formula for compounding inflation, and i need to
have that result to be rounded (example, one result from the formula is
$877,394) I want to have that number read $877,400, but within the same cell,
not in a different cell or column. how do i get both formulas in a single
cell? i've got the formulas for interest and for rounding but i can't get
them to work together in a cell, gives me a circular error.