Hello,
first I must say that I'm impressed and motivated by people on this forum to explore excel and to learn a few tricks... so thank you.
Im trying to create VBA Userform to replace my excel calculator for some home business. And I'm stuck with following:
How to create formula that will calculate number of millions in big multimillion number? I was using Rounddown in excel, but since Rounddown is not optional in VBA, I'm asking for help.
What i want to achieve is to calculate value based on input number, in case that up to 7.000.000 value is 50 but for any value above 7.000.000 final value has to be calculated based on 50 +(1 for each starting million). For example: input of 7.000.000 gives 50, input of 8.954.000 gives 51, input of 11.010.000 is 54 etc...
I would appreciate any idea... sorry if my explanation is a bit confusing, English is not my primary language...
first I must say that I'm impressed and motivated by people on this forum to explore excel and to learn a few tricks... so thank you.
Im trying to create VBA Userform to replace my excel calculator for some home business. And I'm stuck with following:
How to create formula that will calculate number of millions in big multimillion number? I was using Rounddown in excel, but since Rounddown is not optional in VBA, I'm asking for help.
What i want to achieve is to calculate value based on input number, in case that up to 7.000.000 value is 50 but for any value above 7.000.000 final value has to be calculated based on 50 +(1 for each starting million). For example: input of 7.000.000 gives 50, input of 8.954.000 gives 51, input of 11.010.000 is 54 etc...
I would appreciate any idea... sorry if my explanation is a bit confusing, English is not my primary language...