LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 6
Default Thanks Macropod, Bill and Sandy

Thanks fellas for your input in helping me out.
You fellas and all the others who help people with their problems are
indisensible to blokes like me.
Regards Pete


"Potaroo" wrote in message
...
I'm after a formula that will give me the closest to a 0.25 incremental
ending.
That is if the sum ends up being 4.29, I need it to return a 4.25
If it ends up being 2.8 I need it ot return a 2.75.
If it ends up being 2.89 I need it ot return a 3.
Is there such a method?
TIA to all you Gurus.
Pete




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rounding Down Formula Lilbit Excel Worksheet Functions 2 March 1st 07 09:55 PM
Rounding up Formula milsupport Excel Worksheet Functions 8 May 31st 06 10:32 AM
rounding a formula with sum nikicole134 Excel Discussion (Misc queries) 5 March 1st 06 02:23 PM
Rounding with the sum formula pgruening Excel Discussion (Misc queries) 3 January 2nd 06 08:20 PM
rounding formula Joel Allen Excel Worksheet Functions 3 September 20th 05 12:05 AM


All times are GMT +1. The time now is 01:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"