required % in decimal places

[vmohan1978]

all,
I am using the formula IF(C33>B33,$H$32,$G$32)&TEXT(((B33-C33)/B33),"#%"), but i am getting the result as
▲51% .... but i need in 2 decimal places...like 51.38%


G32
▲
H32
▼

B(33) C (33)
8368219.99 12668219.99

 

[Nebu]

Hi:
Use

"#.##%"

Thanks

 

[Khalid NGO]

Hi Mohan,
I am not sure about your formula output, but for the format with 2 decimals you can try:
=IF(C33>B33,$H$32,$G$32)&TEXT(((B33-C33)/B33),"#.00%")

Regards,

Edit: Didn't noticed Nebu already replied

 

[Rozy Rahmani]

Hi Team,

I want to attach any file in excel sheet. Is this possible or not? if this is possible please tell me how to attach please send the reply step by step.

 

[Rozy Rahmani]

How to ask any new question in forum because i have no idea. where i post my questions?

 

[Khalid NGO]

Hi Team,

I want to attach any file in excel sheet. Is this possible or not? if this is possible please tell me how to attach please send the reply step by step.

Hi Rozy,
yes definitely you can upload.
use "Upload a File" button at the bottom of page (write your reply)

and also visit the links here:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

Regards,