Problem With Dollar Function

Agree with daddylonglegs.
That's what I was talking about: if you use DOLLAR function in some other workbook where you want Rs as result you will get $ (cause you change regional settings).

Maybe you want that, I don't know. But you need to keep that in mind.