In Excel, I'm calculating column sums using the formula =SUM(A1:A10) as well as B1..10 and C1..10. Please excuse my poor English, but column A stands for "h" (hectare), column B for "a" (are, which is similar to an acre but not an acre), and column C for "m." (square meters).
I need to style my sum so that it looks like this: A B C -> 4 07 45. My sum ultimately appears in columns A B C -> 3 105 245 accordingly. What does it mean in code?
Once again, I apologize. Because I don't speak English very well and don't know what that calculation is called in English, I'm unable to google it.
Apr 2, 2023 in Others 609 views

## 1 answer to this question.

To get hectare (F2):

```=A2+QUOTIENT(B2*100+C2,10000)
```

or

```=QUOTIENT(A2*10000+B2*100+C2,10000)
```

To get are (G2):

```=QUOTIENT(MOD(B2*100+C2,10000),100)
```

To get square meters (H2):

```=MOD(C2,100)
```

Result:

• 38,010 points

## How to format numbers as lakhs and crores in excel/ google spreadsheet when the number could be negative too?

Excel formatting, in my opinion, can only ...READ MORE

## How to format numbers in excel in crores or lacks

Try this: =TEXT(A1/10000000,"#,### \cr") READ MORE

## How to change the default number format in Excel?

Excel Tips, Learn Excel \ Raghu R Setting ...READ MORE

## Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

Forget the PsychoPy complications for the time ...READ MORE

## In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

## Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE