Hi all,
I need a macro (only macro, not a formula) that will multiply numbers by 1.35 and ONLY AFTER THAT will round them, subject to their value, according to the following model:
0 to 99 - multiply by 1.35 and round to the nearest 10
100 to 999 - multiply by 1.35 and round to the nearest 50
1,000 to 9,999 - multiply by 1.35 and round to the nearest 100
10,000 to 99,999 - multiply by 1.35 and round to the nearest 1,000
100,000 to 999,999 - multiply by 1.35 and round to the nearest 10,000
1,000,000 or more - multiply by 1.35 and round to the nearest 100,000
Please see the file attached, on column A you can see a few sample numbers, on column C you can see the desired results.
Any help will be highly appreciated,
Sami
Bookmarks