My equation does not work as I want.
=CONCATENATE("Dollars $ ",ROUNDUP(2,SUM(F2:F2000)))
It produces 'Dollars $2'.
It should produce 'Dollars $ 62.25'.
Thanks for your help.
Mike
My equation does not work as I want.
=CONCATENATE("Dollars $ ",ROUNDUP(2,SUM(F2:F2000)))
It produces 'Dollars $2'.
It should produce 'Dollars $ 62.25'.
Thanks for your help.
Mike
Small change to yours
Please Login or Register to view this content.
Thank you Maniacb.
I knew I had the order wrong.
I changed it to RoundDown. Now it works perfect.
Thanks Again
Mike
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks