|
|
|
|
|
|
Welcome to the Australian Ford Forums forum. You are currently viewing our boards as a guest which gives you limited access to view most discussions and inserts advertising. By joining our free community you will have access to post topics, communicate privately with other members, respond to polls, upload content and access many other special features without post based advertising banners. Registration is simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. Please Note: All new registrations go through a manual approval queue to keep spammers out. This is checked twice each day so there will be a delay before your registration is activated. |
|
|||||||
| The Bar For non Automotive Related Chat |
 |
|
|
Thread Tools | Display Modes |
11-05-2006, 10:24 AM
|
#1 | ||
|
FF.Com.Au Hardcore
Join Date: Dec 2004
Posts: 22,922
|
I have a heap of numbers i need to round down, as they are sales units and we all know you cant have .34 of a unit etc.
I tried to do this with the excel Round Down function but its weird, doesnt seem to do what i want it to? Can anyone help me?
__________________
2022 RAM Laramie 5.7 2023.50 Ranger Wildtrak 3.0 V6 Premium Pack 2024 Everest Sport 3.0 V6 Touring Pack 2024.50 Mustang Darkhorse 6M Blue Ember + Appearance pack ETA Jan 25. |
||
|
|
|
11-05-2006, 10:30 AM
|
#2 | ||
|
Guest
Posts: n/a
|
Use INT function
Rounds down to the nearest whole number =Int(number/cell) If you need to find a excel function, in a cell, press =, then next to the formula edit line there should be a drop down list of previously used functions. Click the list and hit "More Functions" where you can then search for functions. |
||
|
|
|
11-05-2006, 10:51 AM
|
#3 | ||
|
^^^^^^^^
  
Join Date: Jan 2005
Location: online - duh
Posts: 9,642
|
=ROUNDDOWN(cell ref or number you want to round down, 0) should do what you want.
__________________
.  |
||
|
|
|
|
11-05-2006, 11:01 AM
|
#4 | ||
|
FF.Com.Au Hardcore
Join Date: Apr 2005
Posts: 4,409
|
You can also use the FLOOR function to round down by .05c at at time
=FLOOR(G32,0.05) to round down by .o5c or =FLOOR(G33,1) to round down by 1 ( can be set to whatever you want ) Pete |
||
|
|
|
|
11-05-2006, 12:57 PM
|
#5 | ||
|
FF.Com.Au Hardcore
Join Date: Dec 2004
Posts: 22,922
|
Cheers guys, see Ford forums is handy for other Non ford related items to, like Excel.
__________________
2022 RAM Laramie 5.7 2023.50 Ranger Wildtrak 3.0 V6 Premium Pack 2024 Everest Sport 3.0 V6 Touring Pack 2024.50 Mustang Darkhorse 6M Blue Ember + Appearance pack ETA Jan 25. |
||
|
|
|
|
11-05-2006, 01:02 PM
|
#6 | ||
|
FF.Com.Au Hardcore
Join Date: Apr 2005
Posts: 4,409
|
I doubt there would be any problem that can't be sorted for excel.
|
||
|
|
|
|
11-05-2006, 01:14 PM
|
#7 | ||
|
Guest
Posts: n/a
|
For a moment there I thought the thread title said "run-down function on excel"... I thought it came as a standard feature from Hyundai...
|
||
|
|
|
11-05-2006, 09:18 PM
|
#8 | ||
|
Ute Forum Moderator
 
Join Date: Dec 2004
Location: Melb
Posts: 7,227
|
Ok, another challenge for the Excel experts - how could you pick up on which one cell within a row contains an entry (a letter or number). I have it 'kind of' working with "NOT(NA())", but it doesn't work for everything, eg only up to letter n - o to z are not detected.
|
||
|
|
|
|
11-05-2006, 10:28 PM
|
#9 | ||
|
FF.Com.Au Hardcore
Join Date: Apr 2005
Posts: 4,409
|
can you give a better example ? if you want to know the exact cell ref you will need a small macro, if yu just need to know if there is something in the cell or not a formula can do this
supply example and can give you an answer Pete |
||
|
|
|
Round Down Function in Excel??
Linear Mode
