Excel convert to hectares!
djdedal
-
Ro -
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
Thank you for your helpful advice in advance!
Best regards
Configuration: Windows XP Internet Explorer 6.0
1 answer
-
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
