|
2021년 1월부터 기존 파일 형식을 더 이상 사용할 수 없습니다. 기존 파일을 전환하거나 PDF를 다운로드할 수 있습니다. 자세히 알아보기

Formula FLOOR

답변함
데모 요청하기

hii,

I want to round down a particular number and I see we have Mround but it rounds to the nearest multiple, can we also include FLOOR ? so it rounds down to the nearest multiple ?

1

댓글

댓글 2개

날짜 투표수
  • Brandon Ehrecke

    Hi Shreya,

    Thank you for reaching out. The FLOOR formula isn't currently supported, but you can achieve the same outcome with ROUNDDOWN and some math. Take a look at this example below for reference. Please let us know if you have any additional questions. Thanks!

    0
  • Shreya Shetty

    thank you, this helped!

    0

댓글을 남기려면 로그인하세요.