Formula FLOOR

已回答

申请演示

2023年12月15日 12:18

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 ?

2 条评论

Brandon Ehrecke

2023年12月18日 20:01
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

2024年07月01日 11:54
thank you, this helped!
0

请先登录再写评论。