View original (French)

Excel convert to hectares!

djdedal -  
 Ro -
Hello, I would like to learn about a formula to convert square meters into hectares, ares, and centiares!!

Thank you for your helpful advice in advance!

Best regards
Configuration: Windows XP Internet Explorer 6.0

1 réponse

Réponse 1 / 1
gbinforme Posted messages 14930 Registration date   Status Contributeur Last intervention   4 742
 
Hello

I suggest this with cell A1 containing the area to be translated:

=INT(A1/10000)" ha "&INT(CNUM(RIGHT(A1;4))/100)" a "&RIGHT(A1;2)" ca"

And if you don't want to display zero values:

=IF(LEN(A1)>4;INT(A1/10000)" ha ";)&IF(AND(LEN(A1)>2;CNUM(LEFT(RIGHT(A1;4);2))>0);INT(CNUM(RIGHT(A1;4))/100)" a ";)&IF(CNUM(RIGHT(A1;2))>0;CNUM(RIGHT(A1;2))" ca";)
--

Always zen
12
Ro
 
Excellent answer. And the reverse? Converting hectares to m²???
0