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 |