View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
david_b2 david_b2 is offline
external usenet poster
 
Posts: 5
Default how do i add a function to a formula?

Thanx that was exactly what I was looking for.

"David Biddulph" wrote:

"david_b2" wrote in message
...
I would like to add the "Round" function to a formula like,
"=G4*(0.076/12)"


Yes, you can do that.

=ROUND(G4*(0.076/12),2), for example.

Or, if you're not trying to apply the ROUND to the result but to one of the
intermediate terms, you can use =G4*ROUND(0.076/12,6), for example.
--
David Biddulph