View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
cybergardener cybergardener is offline
external usenet poster
 
Posts: 10
Default Round up or down

I just put =ROUND((F10*0.005),2) in cell G10 and it looks like it works.
--
Thanks
Cyber Gardener


"cybergardener" wrote:

I can't get a number to round correctly. H10 should be 2072.92 but my
formula comes up as 2072.93. Can you please help me with this senario? This
is what I have in the following cells.

E10 52083.60
F10 =E10*0.04
G10 =F10*0.005
H10 =F10-G10
--
Thanks
Cyber Gardener