Divide Function

smadiraju · New User Joined: 19 Dec 2008 Posts: 3 Location: Chennai

Require information like how it calculates the values of X???

X= fixed dec (6,2)

X = ROUND (DIVIDE ((A * 100),B,8,5),4);

A= 00000000048.29
B = 00000001609.74

X = ?????

donateeye · New User Joined: 01 Jun 2007 Posts: 62 Location: chennai

Answer is 2.9999

divide has four parameters :
1 - number from which divide should happen
2 - number to divide
3 - number of digits before the point
4 - number of digits after the point

and Round makes it to the specified digits.. in this case its 4, so it cuts till 4 digit depending on the fifth (if exists) digit, that is, if the 5th digit is >5 then fourth digit will be added to one.

Please correct me anyone if I am wrong..

smadiraju · New User Joined: 19 Dec 2008 Posts: 3 Location: Chennai

Thanks for your response.