Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 964
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Don't Round... Michael Miazga Excel Discussion (Misc queries) 7 July 20th 07 11:47 PM
ROUND Novice2000 Excel Discussion (Misc queries) 2 July 11th 07 04:14 PM
Round up Becky Paine Excel Discussion (Misc queries) 10 June 12th 06 10:43 PM
How do I ROUND() round off decimals of a column dataset? Højrup Excel Worksheet Functions 2 January 12th 05 11:50 AM
how do I round up? Martushka Excel Worksheet Functions 1 January 3rd 05 08:30 PM


All times are GMT +1. The time now is 08:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"