Thread: More function than FLOOR() !
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default More function than FLOOR() !
On Mon, 4 Aug 2008 13:29:42 -0700 (PDT), joeu2004 wrote:

FLOOR(A1 - 1, 10) seems to do what you want, as long as A1 is at least
1.

A1 would also have to be an integer, wouldn't it?
--ron
Reply With QuoteReply With Quote