Aidworker17
New Member
Dear All,
Our team is continuing the distribution of free seeds to women in the north of Uganda - more than 14,000 women.
Thanks to some previous help from all of you, I have amassed a large data base - that contains a variety of information.
I have a column of data that can contain any number between 1 and 15 in increments of 0.25 (the cells are formatted to have 2 places after the decimal point).
Here are all the possibilities (I have put them in rows, just to save space in this query ) :
0.25 0.50 0.75 1.00 1.25 1.50 1.75 2.00 2.25 2.50 2.75 3.00 3.25 3.50 3.75 4.00 4.25 4.50 4.75 5.00 5.25 5.50 5.75 6.00 6.25 6.50 6.75 7.00 7.25 7.50 7.75 8.00 8.25 8.50 8.75 9.00 9.25 9.50 9.75 10.00 10.25 10.50 10.75 11.00 11.25 11.50 11.75 12.00 12.25 12.50 12.75 13.00 13.25 13.50 13.75 14.00 14.25 14.50 14.75 15.00
What I want to do is round down any number that has a ".25" or a ".75" So :
- If the number ends in ".25", then I want to change it to ".00" For example, I want 5.25 to become 5.00
- If the number ends in ".75", then I want to change it to ".50" For example, I want 5.75 to become 5.50
I imagine it has something to do with isolating the digits after the decimal point from the whole number. Then :
- if they are .25 change them to .00, then join them back to the whole number
- if they are .75 change them to .50, then join them back to the whole number
What do you think ?
Kind regards,
Jonathan.
Our team is continuing the distribution of free seeds to women in the north of Uganda - more than 14,000 women.
Thanks to some previous help from all of you, I have amassed a large data base - that contains a variety of information.
I have a column of data that can contain any number between 1 and 15 in increments of 0.25 (the cells are formatted to have 2 places after the decimal point).
Here are all the possibilities (I have put them in rows, just to save space in this query ) :
0.25 0.50 0.75 1.00 1.25 1.50 1.75 2.00 2.25 2.50 2.75 3.00 3.25 3.50 3.75 4.00 4.25 4.50 4.75 5.00 5.25 5.50 5.75 6.00 6.25 6.50 6.75 7.00 7.25 7.50 7.75 8.00 8.25 8.50 8.75 9.00 9.25 9.50 9.75 10.00 10.25 10.50 10.75 11.00 11.25 11.50 11.75 12.00 12.25 12.50 12.75 13.00 13.25 13.50 13.75 14.00 14.25 14.50 14.75 15.00
What I want to do is round down any number that has a ".25" or a ".75" So :
- If the number ends in ".25", then I want to change it to ".00" For example, I want 5.25 to become 5.00
- If the number ends in ".75", then I want to change it to ".50" For example, I want 5.75 to become 5.50
I imagine it has something to do with isolating the digits after the decimal point from the whole number. Then :
- if they are .25 change them to .00, then join them back to the whole number
- if they are .75 change them to .50, then join them back to the whole number
What do you think ?
Kind regards,
Jonathan.