Thread: how to round a cell value in formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default how to round a cell value in formula
On Tue, 24 Jan 2006 18:57:04 -0800, "Ducky"
wrote:

If a cell contains a value such as 4.13, but in a formula I want to use the
rounded value which would be 4, how do I do that?
'
=ROUND(4.13,0)


--ron
Reply With QuoteReply With Quote