i made a calculation z =(x)/(y*y) but z is having lots of decimals , i just want integer by using interger(number) can anyone help me please how to attch next step to above calculation

Give us some examples of the exact outcome, which would be a business decision. It would depend upon how the functions are applied.

For instance if x = 100 and y = 23 then:

x / ( y * Y ) = .1890359168241966

Div ( x ; y * y ) = 0

Round ( x / ( y * y ) ; 2 ) = .19

Int ( x / ( y * y ) ) = 0

... and so forth. If you are unsure of the exact business rules, provide some examples (at least five with acceptable decimal places in the starting numbers) and the results expected. From the examples, we can provide the function. The result would probably be question of rounding.

should i paste the calculation as it is because i am not understanding how to end and add steps into script

We are not talking script (even if you end up using the calculation in script). What we know to know are the expected results from several different combinations or simply provide the rules.

But if you are happy with the results you are achieving, simply add your calculation which got you to that end number with Int(). Otherwise, we need more information. :wink2:

i made a calculation z =(x)/(y*y) but z is having lots of decimals , i just want integer by using interger(number) can anyone help me please how to attch next step to above calculation

There is no "next step" - just make the calculation =

Div ( x ; y^2 )