View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Two functions in one cell???

Yes

=round(average(range),2)

or whatever

You can combine many functions, the main thing to remember is you can
only nest brackets up to 7 levels or Excel will refuse to handle it.