Thread: floor formula features - help.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
s. Dost[_2_] s. Dost[_2_] is offline
external usenet poster
  
Posts: 1
Default 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?
Reply With QuoteReply With Quote