good day guys / girls
i have a list of properties, with the size (in hectare) of their respective erven like below
size
1
0.2
0.1
0.984
0.1
1.3714
5.0782
0.99
1
0.4268 etc etc
what formula do i use to make a 1 next to all properties with value smaller than 1 hectare, and then repeat in next column with equal to 1, and next column larger than one etc. so that i can tally up all the sizes ?
hope this makes sense
TIA
-----
edit
typical, as soon as i post i manage to get it right (smaller as, or bigger as 1 etc), but how would i get it right to return the following ?
≤ 1,0 Ha
> 1,0 Ha ≤ 1.5Ha
> 1,5 Ha ≤ 2,0Ha
> 2,0 Ha ≤ 3,0Ha
etc
TIA Agian
i have a list of properties, with the size (in hectare) of their respective erven like below
size
1
0.2
0.1
0.984
0.1
1.3714
5.0782
0.99
1
0.4268 etc etc
what formula do i use to make a 1 next to all properties with value smaller than 1 hectare, and then repeat in next column with equal to 1, and next column larger than one etc. so that i can tally up all the sizes ?
hope this makes sense
TIA
-----
edit
typical, as soon as i post i manage to get it right (smaller as, or bigger as 1 etc), but how would i get it right to return the following ?
≤ 1,0 Ha
> 1,0 Ha ≤ 1.5Ha
> 1,5 Ha ≤ 2,0Ha
> 2,0 Ha ≤ 3,0Ha
etc
TIA Agian
Last edited: