Hi All
If my resulting number is a negative one i.e
variation.text = -23.214 I need it to be 24
and if the number is positive i.e
variation.text = 23.214 I need it to be 23
How do I go about solving this?
thanks
Rob
Printable View
Hi All
If my resulting number is a negative one i.e
variation.text = -23.214 I need it to be 24
and if the number is positive i.e
variation.text = 23.214 I need it to be 23
How do I go about solving this?
thanks
Rob
Using the immediate window I get:
? int(23.214)
23
? int(-23.214)
-24
If you need your result to be positive (absolute number) then use abs() function to get final result:
? abs(int(23.214))
23
? abs(int(-23.214))
24
Does that help? SgarV
Thanks for your prompt reply, it worked a treat.
Keep up the good work
Rob:wave: