ExcelBanter - Is there a way to round currency?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Is there a way to round currency? (https://www.excelbanter.com/excel-discussion-misc-queries/61943-there-way-round-currency.html)

jpowers

Is there a way to round currency?

Is there a way to round currency with cents=.50 to .99 and cents <=.49 to .49?

Ron Coderre

Is there a way to round currency?

Try this:

For a value in A1
B1: =FLOOR(A1,0.5)+0.49

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

"jpowers" wrote:

Is there a way to round currency with cents=.50 to .99 and cents <=.49 to .49?

All times are GMT +1. The time now is 01:03 AM.