Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
sypher
 
Posts: n/a
Default I am trying to round up to the nearest 25 cents

I am trying to round a money value to the nearsest 25 cents and it keeps
rounding to the nearest dollar HELP

  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

Try

=CEILING(A1, 0.25)

In article ,
sypher wrote:

I am trying to round a money value to the nearsest 25 cents and it keeps
rounding to the nearest dollar HELP

  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

=ROUND(A1*4,0)/4

--
HTH

Bob Phillips

"sypher" wrote in message
...
I am trying to round a money value to the nearsest 25 cents and it keeps
rounding to the nearest dollar HELP



Reply
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
Round time to nearest quarter hr John Excel Worksheet Functions 2 March 16th 05 10:41 PM
How do I format cells to round to the nearest thousands without .. excel user Excel Discussion (Misc queries) 1 March 16th 05 09:10 PM
WHAT SYNTAX IS USED TO ROUND A 4-DIGIT NUMBER TO THE NEAREST THOUS KENITOSAN Excel Discussion (Misc queries) 4 February 19th 05 11:06 PM
WHATS AN EASY FUNCTION TO USE TO ROUND TO THE NEAREST THOUSAND? Martina Excel Worksheet Functions 4 January 9th 05 02:35 PM
How can I round an hour to the nearest 1/4 hour? Ms Chewie Excel Worksheet Functions 5 December 21st 04 06:05 AM


All times are GMT +1. The time now is 11:36 PM.

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

About Us

"It's about Microsoft Excel"