How do I round to the nearest 25 cents in Excel?
B Bill Kuunders Jan 26, 2007 #2 one way number is in A1 =ROUND(A1/25,2)*25 formatted to two fixed decimals
R Ron Coderre Jan 26, 2007 #3 Try this: With A1: (a number) B1: =ROUND(A1/0.25,0)*0.25 Does that help? *********** Regards, Ron XL2002, WinXP
Try this: With A1: (a number) B1: =ROUND(A1/0.25,0)*0.25 Does that help? *********** Regards, Ron XL2002, WinXP
