Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Am using one formula into text object and output is coming 0.0092228146015614 and -11.881221060977
So I want output like 0.9% and -11.9%
Can you please tell me how to achieve it.
Thanks
Hi,
Use NUM function as Num(Sales,'#,##0.00%')
HTH
sushil
Hi,
Try like
If(expression>0,expression*100,expression)& ' %'
Regards,
you can format using num function
num(your expression,'#0.0')
Num(Sales,'0.0%')
For first expression you need to use if condition along with Num (),
=Num(if(num(0.0092228146015614,'#.##')<.1,num(0.0092228146015614,'#.##')*100,0.0092228146015614),'##.#')
for second you can directly use Num()
= Num(-11.881221060977,'#.#')
Thanks
BKC
Your request is quite difficult to accomplish. When using the num function with a format string that contains a percentage mark you will get an implicit multiplication by 100. For example:
0 -> 0%
0.5 -> 50%
1 -> 100%
num(0.009, '0.0%') will produce 0.9% as required. But num(-11.88, '0.0%') will produce... er -1188% and not -11.9%.
Isn't that what you want?
Peter
Hi
For rounding you can try
Num(If(expression>0,expression*100,expression),'#,#0.0')& ' %'
regards
replace hard coded values with expression