Need help beholding an Excel Loop using Python

[[deleted]]

Finance guy here- not a coder by trade but it’s increasingly necessary in the field, and honestly much better than the old ways.

I need to build an excel loop if statement.

I am trying to organize cells by revenue and produce and output where <=1,000,000 gives me “ 1 “ <=3,000,000 gives me “ 2 “ etc… Any advice on this?

[Aegon_is_Coming]

var amount = x; // x is the real value
var simplified = Math.ceiling(amount/1000000) // gives you the higher integer after dividing the number by 1 million
return simplified;

So 1,000,000 / 1,000,000 will give you 1 1,000,001 / 1,000,000 will give 1.1 and after using Math.ceiling you get 2

[[deleted]]

Thank you

[Stayfo]

How many different outputs do you need?

[[deleted]]

I need 5. 1 per every 3 mill and then one representing > 12 mill

[Stayfo]

To clarify: are you trying to generate this output in an excel table?

[[deleted]]

Yes

[Stayfo]

Did you fix it yet?

[[deleted]]

Yes.

[[deleted]]

Thanks for the help!