Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to divide two expressions by one another and the end result to give me xx.0. I have used the below and the answer I get is xx.xxxxxxxxxxxxx. What am I doing wrong?
=num(expression1), '##.0') / num(expression2). '##.0')
=num(expression1 /expression2, '##.0')
Hi
try this:
=num((expression1), '##.0') / num((expression2), '##.0')
thanks for the reply but this does not solve my query.
Hie..
Goto chart properties-->>Numbers Tab-->>Select Integer-->>in that '##.0'
Hope this will helps you..!!
Regards,
Mohammad
Hi
Unfortunately I am using text box properties and your suggestion is not available.
Try this
=num(num((expression1), '##.0') / num((expression2), '##.0'),'##.0'))
or
=num(expression1 /expression2, '##.0')
Hope this will helps you..!!
Regards,
Mohammad
=num(expression1 /expression2, '##.0')
can you post your expression?
=num(expression1/expression2), '##.0')