| Author |
Message |
    
sportsnut
Citizen
Username: Sportsnut
Post Number: 2234
Registered: 10-2001
| | Posted on Tuesday, December 27, 2005 - 8:52 pm: |     |
If I have the following numbers:
3.12
1.07
2.28
and I want them rounded to the following numbers:
3.15
1.10
2.30
or rounded up to the nearest 5 is there a way to do it via formula?
Thanks |
sportsnut
Citizen
Username: Sportsnut
Post Number: 2235
Registered: 10-2001
| | Posted on Tuesday, December 27, 2005 - 9:26 pm: | |
Never mind found it. |
Dave
Supporter
Username: Dave
Post Number: 8229
Registered: 4-1997
| | Posted on Tuesday, December 27, 2005 - 9:29 pm: | |
How did you crack it? Did you use MROUND or ROUNDUP? |
sportsnut
Citizen
Username: Sportsnut
Post Number: 2236
Registered: 10-2001
| | Posted on Tuesday, December 27, 2005 - 9:54 pm: | |
I used the following formula:
=ROUNDUP(E1/0.05,0)*0.05
Where E1 is the data that I want to round. |
sac
Supporter
Username: Sac
Post Number: 2966
Registered: 5-2001
| | Posted on Tuesday, December 27, 2005 - 10:05 pm: | |
Cool!
(It's amazing what will amuse us math geeks, isn't it?) |
Tom Reingold
Supporter
Username: Noglider
Post Number: 11605
Registered: 1-2003
| | Posted on Wednesday, December 28, 2005 - 12:25 am: | |
...and word geeks. The word you wanted was datum.
Just teasing you, sportsnut.
|
Closed: New threads not accepted on this page