View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Heather Heather is offline
external usenet poster
 
Posts: 148
Default How to use Ceiling to round?

Can anyone help me with a rounding issue

I have a formula that looks like this

F7*F27
16,995*.92134 = 15,658.17

I then need to Round to the nearest 500 and then subtract 5

15,659 rounded to the neares is 15,500 then subtract 5 = 15,495