G Guest Dec 27, 2005 #1 Is there a way to round currency with cents>=.50 to .99 and cents <=.49 to .49?
G Guest Dec 27, 2005 #2 Try this: For a value in A1 B1: =FLOOR(A1,0.5)+0.49 Does that help? *********** Regards, Ron XL2002, WinXP-Pro
Try this: For a value in A1 B1: =FLOOR(A1,0.5)+0.49 Does that help? *********** Regards, Ron XL2002, WinXP-Pro
