Link to home
Start Free TrialLog in
Avatar of AmitJain001
AmitJain001

asked on

VB Script Round Function is not functioning correctly.

Hi Experts,

In vb script I have sent an arithmetic expression which is divisible by 2 is not rounding correctly : eg;
"Eval" functions return 80 for expression 80.5 but it should be rounded to next number.
how can this be achieved

I have tried evaluating following expression but it also throws error :

Val(Format((( 23 + 24 + 22 + 18 + 21 + 23 + 21 + 23 ) /2.0 ) ,"0") )

Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Jacques Bourgeois (James Burger)
Jacques Bourgeois (James Burger)
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of AmitJain001
AmitJain001

ASKER

thnx JamesBurger, I have raised it under another topic now.