| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round 1.45 down to 1.25 and 1.57 down to 1.50
I need to be able to round numbers down every time. We allocate 1 eight hour
employee for every 20000 SQ feet, jobs are given in 2 hour increments. EX: 20000 Sq feet would equal 1 eight hour employee 29000 Sq feet = 1.45 not enough for another 2 hour employee so my answer would need to be 1.0 25000 Sq feet would equal 1 eight hour employee and 1 two hour employee |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Round 1.45 down to 1.25 and 1.57 down to 1.50
Try this:
=FLOOR(A1/20000,0.25) HTH, Elkar "joker007" wrote: I need to be able to round numbers down every time. We allocate 1 eight hour employee for every 20000 SQ feet, jobs are given in 2 hour increments. EX: 20000 Sq feet would equal 1 eight hour employee 29000 Sq feet = 1.45 not enough for another 2 hour employee so my answer would need to be 1.0 25000 Sq feet would equal 1 eight hour employee and 1 two hour employee |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Round 1.45 down to 1.25 and 1.57 down to 1.50
Thank you this will make life alittle easier
"joker007" wrote: I need to be able to round numbers down every time. We allocate 1 eight hour employee for every 20000 SQ feet, jobs are given in 2 hour increments. EX: 20000 Sq feet would equal 1 eight hour employee 29000 Sq feet = 1.45 not enough for another 2 hour employee so my answer would need to be 1.0 25000 Sq feet would equal 1 eight hour employee and 1 two hour employee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Don't Round... | Excel Discussion (Misc queries) | |||
| ROUND | Excel Discussion (Misc queries) | |||
| Round up | Excel Discussion (Misc queries) | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
| how do I round up? | Excel Worksheet Functions | |||
Linear Mode
