| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
floor formula features - help.
I'm trying to build a range for charting purposes. The D342 is 1000, and the
FLOOR is 1000. So, the result of FLOOR and CEILING combined comes out like this: 1000-1000 - but I want it to be 0000-1000. The formula is '=FLOOR(D342,1000)'. How can I get the FLOOR result to be 0-1000? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
floor formula features - help.
Maybe this will work for you
=FLOOR(D342-10^(-10),1000) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "s. Dost" wrote in message ... I'm trying to build a range for charting purposes. The D342 is 1000, and the FLOOR is 1000. So, the result of FLOOR and CEILING combined comes out like this: 1000-1000 - but I want it to be 0000-1000. The formula is '=FLOOR(D342,1000)'. How can I get the FLOOR result to be 0-1000? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| More function than FLOOR() ! | New Users to Excel | |||
| floor function | Excel Worksheet Functions | |||
| is there a way of drawing floor plans within office | New Users to Excel | |||
| Something like CEILING or FLOOR | Excel Worksheet Functions | |||
| ceiling & floor | New Users to Excel | |||
![s. Dost[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
