ExcelBanter - floor formula features

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - floor formula features - help. (https://www.excelbanter.com/excel-worksheet-functions/198842-floor-formula-features-help.html)

s. Dost[_2_]

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?

Bob Phillips

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?

All times are GMT +1. The time now is 07:16 PM.